SQL Help?
| From: | Barry Prentiss | Date: | Thu, 16 Aug 2001 21:30:45 +0000 |
| Subject: | SQL Help? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11461@lists.php.net to get a copy of this message | ||
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