ASPN ActiveState Programmer Network
ActiveState
/ Home / Perl / PHP / Python / Tcl / XSLT /
/ Safari / My ASPN /
Cookbooks | Documentation | Mailing Lists | Modules | News Feeds | Products | User Groups


Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming


MyASPN >> Mail Archive >> php-db
php-db
[PHP-DB] If in a query
by Shaun other posts by this author
Sep 27 2003 1:40PM messages near this date
RE: [PHP-DB] Selecting data from multiple tables | Re: [PHP-DB] Re: If in a query
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
Thread:
Shaun
Director General: NEFACOMP
Shaun

Privacy Policy | Email Opt-out | Feedback | Syndication
© ActiveState Software Inc. All rights reserved