Re: How to best migrate this nested join ?

От

David G. Johnston

Тема

Дата

2 марта 2018 г. в 00:31:19

Msg-id

CAKFQuwbxMDhdGiBYe_cERMEjQ1wUsP9Gj0cYKV5ZLUfLNV2fsw@mail.gmail.com

обсуждение

Ответ на

How to best migrate this nested join ? (Gary M)

Список

pgsql-sql

Дерево обсуждения

How to best migrate this nested join ? Gary M <garym@oedata.com> 2 марта 2018 г. в 00:16:58

Re: How to best migrate this nested join ? "David G. Johnston" <david.g.johnston@gmail.com> 2 марта 2018 г. в 00:31:19

Re: How to best migrate this nested join ? Gary M <garym@oedata.com> 2 марта 2018 г. в 03:15:09

On Thu, Mar 1, 2018 at 2:16 PM, Gary M <garym@oedata.com> wrote:

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 ?