Hi
UDB 8.05.001

I have 3 tables which I want to join as follows
Table 1
ColA ColB
1 A
2 B
3 C


Table 2
Colc Cold
2 X


Table 3
Cole Colf
3 Z
----------------------------------------------
I know to join two tables which is as follows
select tb1.*, tb2.*
from
SESSION.table1 as tb1
LEFT OUTER JOIN
SESSION.table2 as tb2
on
tb1.colA = tb2.colc
----------------------------------------------
Could anyone give me the syntax for 3 tables I tried couple of things but did
not work.
select tb1.*, tb2.*,tb3.*
from
SESSION.table1 as tb1
LEFT OUTER JOIN
SESSION.table2 as tb2
on
tb1.colA = tb2.colc

I also want to include tb3 and join this on
tb1.colA = tb3.cole



Thanks

I got the syntax.
select tb1.*, tb2.*, tb3.*
from
SESSION.table1 as tb1
LEFT OUTER JOIN
SESSION.table2 as tb2
on
tb1.colA = tb2.colc
LEFT OUTER JOIN
SESSION.table3 as tb3
on
tb1.colA = tb3.cole