Wednesday, November 01, 2006

SQL Question

I have a question for you,

Is there a way to write a sql statement that will return results from
one table only if a something in a specific column does not exist in
another table's specific column?

For example,

table one

price ID
10 A
20 B
30 C

table two

price ID
11 A
23 D
30 F

I want it to return just rows 23 D and 30 F becuase they are unique to
that table and not the other one. Can I do this in SQL?

Thanks

0 Comments:

Post a Comment

<< Home