ryddler, you'll just have to ponder SQL a little bit harder. Because, you can make outer joins as well. Generally:

SELECT name, 'In table2!' FROM table1 
  WHERE ID IN (SELECT ID FROM table2) 
JOIN
SELECT name, 'Not in table2!' FROM table1
  WHERE NOT ID IN (SELECT ID FROM table2);
[download]

Well, this isn't beautiful SQL either, as you write two subselects, but it gets the job done. Whatever the columns and order in which you want it be returned, it really can be done in SQL. Look here for a tutorial.

Jeroen
"We are not alone"(FZ)