I have two tables with a common link

Table1
Column1
Column2
Table2
                Column1
                Column2

I want to find the values in Column2 in Table1 that does not exist in Table2 
based on Column1 in both tables

I tried

Select Column1, Column2 from Table1, Table2 where Table1.Column1 = 
Table2.Column1 and Table1.Column1 <> Table2.Column2

But did not work.

I am drawing a blank. Anyone have ideas on how?

TIA

Dan Goldberg


-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EEC8183%40EXCHANGE10.

Reply via email to