Hello List,
I have 2 identical tables, table1 and table2 with 2 fields:
id int and idname varchar(30). I am successful in retrieving the records
in table1 not in table2 with:
select id from table1 except select id from table2;
id
-----
1
2
3
...
which is great. It would be even greater if I can get the table1.idname
as part of the output, for example:
id idname
----- ------
1 rice
2 beans
3 soy
...
something tells me I need to make my query a subquery of something else,
but can't quite figure it out.
thanks for any pointers
george