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
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