Subquery

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