Joins

[Saurabh Saha]

Hi All,
Please tell me how to use outer and Inner joins for more than two tables.

Thanks,
Vivek

[Jeanne Boyarsky]

Vivek,
It works the same way as for two tables. Just make sure you chain the tables in a where clause. For example,

select a.* from
table1 a, table2 b, table3 c
where a.id = b.id and b.field = c.field