Re: How to best migrate this nested join ?

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 ID4FROM    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 ?