Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
DB2 & PHP - SQL commands
0 views
Skip to first unread message
Bodzek
Jun 13, 2004, 6:54:07 PM6/13/04
to
Hi,
Please let me know, Could I get data from DB2 using command SQL: LEFT JOIN
and INNER JOIN in web application PHP?
Thanks
Marcin
Dan Scott
Jun 14, 2004, 8:39:13 AM6/14/04
to
Sure, just issue your SELECT statement incorporating the LEFT JOIN or
INNER JOIN syntax as you would any other SELECT statement and retrieve
the results as you would with a simple SELECT statement.
INNER JOIN syntax as you would any other SELECT statement and retrieve
the results as you would with a simple SELECT statement.
You can read more about the SELECT syntax for joins at
http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/admin/r0000875.htm#HDRJOINTBL
Here's an example of an INNER JOIN statement from that topic:
SELECT * FROM J1 INNER JOIN J2 ON W=Y
Dan
0 new messages