How to best migrate this nested join ?

Gary M <[email protected]>
Newsgroups gmane.comp.db.postgresql.sql
Message-ID <CAGwOJnyPBNZ_STrxz8dcvW6gFbbxUv3vrCYbmiJrCRw5tvoNRw@mail.gmail.com>
Hi,

I have this nested join taken from some old  sybase code.

SELECT

     TBL1.ID AS ID1,     TBL4.ID AS ID2,     TBL5.ID AS ID3,     TBL6.ID AS ID4

FROM TBL1, TBL2, TBL3, TBL4, TBL5, TBL6, TBL7 WHERE TBL1.AA *= TBL2.AA and
TBL1.AA = TBL3.AA and TBL4.AB = TBL3.CD and AB = 'TBL4' /* not sure where
AB is coming from */ and TBL4.AB = TBL7.AB and TBL7.ZZ = 0 and TBL4.AB *=
TBL6.AB and TBL4.AB *= TBL5.AB ;

How should these joins be nested using pg-sql ?

-g
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.