SQL Help?

Hi,
 Here's another SQL query problem:

How do I construct a query that returns 1 if a value is present and zero if it is not, for a list of values returned in another query?

i.e. select a.id, a.name, c.selected from table-with-id-and-name a,

    (select 1 as selected from another-table b if a.id = b.id      or select 0 as selected from another-table b if a.id != b.id ) c;

 Thx in Advance,
 Barry Prentiss Received on Thu Aug 16 2001 - 23:30:26 CEST