Help with Query
Help with Query
(OP)
Hi Folks,
I have two tables - Part Master and Product Structure. The PRTNUM_01 field in the Part Master table is the same as the PARPRT_02 field in the product structure table.
I want to run a query that will give me all the values from "Part Master".PRTNUM_01 that are not in "Product Structure".PARPRT_02
Any suggestions?
I have two tables - Part Master and Product Structure. The PRTNUM_01 field in the Part Master table is the same as the PARPRT_02 field in the product structure table.
I want to run a query that will give me all the values from "Part Master".PRTNUM_01 that are not in "Product Structure".PARPRT_02
Any suggestions?
Mighty
RE: Help with Query
You can use the NOT IN clause in your select. This is an example from the manual.
SELECT * FROM Person p WHERE p.id NOT IN
(SELECT s.id FROM Student s WHERE Cumulative_Hours = 0)
Regards,
Tom