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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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