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 20030927134011.97570.qmail@pb1.pair.com">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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
