Skip to Content
0
Former Member
Apr 22, 2010 at 12:05 PM

Where Used SQL Query

47 Views

I have a where used SQL query that prompts for a single component, i would like to query 2 components but do not know how to write the query. Here's the single component query:

SELECT T0.[Father], T2.[ItemName], T0.[Code], T1.[ItemName], T0.[Quantity], T0.[Warehouse] FROM ITT1 T0 INNER JOIN OITM T1 ON T0.Code = T1.ItemCode INNER JOIN OITM T2 ON T0.Father = T2.ItemCode WHERE T0.[Code] = [%0] ORDER BY Father

Anyone comment on how to do 2 component where used?

Rich