Re: If in a query
| From: | Shaun | Date: | Sat, 27 Sep 2003 13:43:22 +0000 |
| Subject: | Re: If in a query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30734@lists.php.net to get a copy of this message | ||
i'm sorry,
i rushed that previous post!!!
what i meant to ask was, if the value of B.Column1 is null then can the
query be written such that we dont select A.Column2.
Sorry!
"Shaun" <shaun@mania.plus.com> wrote in message
news:20030927134011.97570.qmail@pb1.pair.com...
> Hi,
>
> is it possible to create a query with parameters such that it selects a
> field if it isn't null?
>
> for example:
>
> SELECT
> A.Column1,
> A.Column2,
> (if not null, B.Column1)
> FROM Table1 A, Table2 B
>
> Thanks for your help