OT: SQL search query

[Robert Orlini]

I'm still new to SQL. I want to search two tables from a form. The search below does not give me any errors, but neither does it generate any hits even though I enter the correct items to look for. How do I edit the SQL to make it search info in both the "purchaseorders" and/or "itemsordered" tables? Thanks.

<cfquery name="Getpo" datasource="purchaseorders">
SELECT * FROM purchaseorders p, itemsordered i
Where 0=0

<CFIF IsDefined("FORM.ponumber")>
And ponumber LIKE '%#FORM.ponumber#%'
</CFIF>

<CFIF IsDefined("FORM.invoicenumber")>
And invoicenumber LIKE '%#FORM.invoicenumber#%'
</CFIF>

<CFIF IsDefined("FORM.vendor")>
And vendor LIKE '#trim(FORM.vendor)#'
</CFIF>

Order by p.cnumber DESC

Robert O.
ô¿ô

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---