SEO

#1 (**permalink**) 02-26-2008, 06:22 PM

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

#2 (**permalink**) 02-26-2008, 06:23 PM

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.

You can read more about the SELECT syntax for joins at
http://publib.boulder.ibm.com/infoce...htm#HDRJOINTBL

Here's an example of an INNER JOIN statement from that topic:

SELECT * FROM J1 INNER JOIN J2 ON W=Y

Dan

Bodzek wrote:
> 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
>
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

DB2 & PHP - SQL commands