Re: SQL Help?

Here's how I did it.... SQL> select cat.*, (select count(faq.cat_id) from mdfaq_faq_cat faq 2 where cat.id = faq.cat_id and faq.faq_id = 23) as selected from mdfaq_category cat; ID NAME ---------- ---------------------------------------------------------------- SELECTED ---------- 6 Solid Edge 0 7 MicroStation 1 10 MDSync 1 Thx for your help. Barry "Barry Prentiss" <thebear@antispam.stanford.edu> wrote in message news:20010816213254.55720.qmail@pb1.pair.com... > 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 > >