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.
"Shaun" <[EMAIL PROTECTED]> wrote in message
> is it possible to create a query with parameters such that it selects a
> field if it isn't null?
> for example:
> (if not null, B.Column1)
> FROM Table1 A, Table2 B
> Thanks for your help
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php