Sorry, forgot to mention that I'm on an Oracle 8.1.6 db...

"Barry Prentiss" <[EMAIL PROTECTED]> wrote in message
> Hi,
>  Here's another SQL query problem:
> How do I construct a query that returns 1 if a value is present and zero
> it is not, for a list of values returned in another query?
> i.e. select,, c.selected from table-with-id-and-name a,
>     (select 1 as selected from another-table b if =
>      or select 0 as selected from another-table b if != ) c;
>  Thx in Advance,
>  Barry Prentiss

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to