Sorry, forgot to mention that I'm on an Oracle 8.1.6 db... Thx, Barry "Barry Prentiss" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]