Обсуждение: AW: [HACKERS] Enhancing PGSQL to be compatible with Informix SQL

Поиск
Список
Период
Сортировка

AW: [HACKERS] Enhancing PGSQL to be compatible with Informix SQL

От
Zeugswetter Andreas SB
Дата:
> > It would be:
> > 
> >     SELECT *
> >     FROM tab1, OUTER tab2
> >     WHERE tab1.col1 = tab2.col2
> 
> What about >2 table joins?  Wish I had my book here, but I though tyou
> could do multiple OUTER joins, no?

select * from tab1, OUTER tab2, OUTER (tab3, tab4), tab5, OUTER tab6, OUTER (tab7, OUTER tab8) where ......

imho understandable syntax.

Andreas