I have this nested join taken from some old sybase code.
SELECT
TBL1.ID AS ID1,
TBL4.IDAS ID2,
TBL5.IDAS ID3,
TBL6.IDAS ID4
FROM TBL1, TBL2, TBL3, TBL4, TBL5, TBL6, TBL7
WHERE TBL1.AA *= TBL2.AA and TBL1.AA = TBL3.AAand TBL4.AB= TBL3.CD and AB ='TBL4' /* not sure where AB is coming from */and TBL4.AB= TBL7.ABand TBL7.ZZ =0and TBL4.AB*= TBL6.AB and TBL4.AB*= TBL5.AB
;