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]
