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.