Re: Problem With Outer Joins

In article <42ntj5$ogp@anarchy.io.com> robbh@bga.com "Robert R. Hunziker" writes: > Using PowerBuilder 3.0c, I cannot get a 3-table join to work correctly > (1 main table, 2 outer-join tables). The SQL syntax generated by PB > is giving an error on the 2nd outer join. Can someone post an Informix > sql statement that uses outer joins. SELECT a.*, b.*, c.* from a, outer b, outer c where a.col1 = b.col1 and a.col2 = c.col2 SELECT a.*, b.*, c.* from a, outer(b, outer c) where b.col1 = a.col1 and c.col2 = b.col2 Take your pick! -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================