How to best migrate this nested join ? - Mailing list pgsql-sql

From Gary M
Subject How to best migrate this nested join ?
Date
Msg-id CAGwOJnyPBNZ_STrxz8dcvW6gFbbxUv3vrCYbmiJrCRw5tvoNRw@mail.gmail.com
Whole thread Raw
Responses Re: How to best migrate this nested join ?
List pgsql-sql
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

pgsql-sql by date:

Previous
From: Gary Stainburn
Date:
Subject: Re: Monthly budgets
Next
From: "David G. Johnston"
Date:
Subject: Re: How to best migrate this nested join ?