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);
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) | [reply]
[d/l] |