Re: SQL Joins - Mailing list pgsql-sql

From steve boyle
Subject Re: SQL Joins
Date
Msg-id a1hd7b$26fk$1@news.tht.net
Whole thread Raw
In response to SQL Joins  (tjennette@thomasnelson.com (Trace))
List pgsql-sql
Trace, is the second SQL in Postgres?

"Trace" <tjennette@thomasnelson.com> wrote in message
news:56893385.0201081316.25272d8c@posting.google.com...
> Can someone please tell me what this previously-written SQL is doing?
> I don't understand how it is structured.  I'm familiar with JOINs such
> as this (1 joined table per 1 ON phrase):
>
> FROM t1
> LEFT OUTER JOIN t2 ON t1.id = t2.id
> LEFT OUTER JOIN t3 ON t2.name = t3.name
>
> But the following SQL is puzzling me.  To which JOINs are the ON
> phrases connected?
>
> Any help would be appreciated!  (Feel free to re-format the physical
> structure of the lines....as this is the way it came to me!)
>
> Trace'
>
>
> FROM eStoreManager.estore_dept_prod LEFT OUTER JOIN
>     eStoreManager.estore_product ON
>     eStoreManager.estore_dept_prod.sku =
> eStoreManager.estore_product.sku
>      RIGHT OUTER JOIN
>     eStoreManager.tblCProductClass
> LEFT OUTER JOIN eStoreManager.tblCProductClassProduct ON
>     eStoreManager.tblCProductClass.ProductClassID =
> eStoreManager.tblCProductClassProduct.ProductClassID
>      ON
>     eStoreManager.estore_product.sku =
> eStoreManager.tblCProductClassProduct.sku
>      FULL OUTER JOIN
>     eStoreManager.tblCProductClassCreator INNER JOIN
>     eStoreManager.tblCCreator
> ON eStoreManager.tblCProductClassCreator.CreatorID =
> eStoreManager.tblCCreator.CreatorID
>     ON eStoreManager.tblCProductClass.ProductClassID =
> eStoreManager.tblCProductClassCreator.ProductClassID




pgsql-sql by date:

Previous
From: "Darryl M. Wolski"
Date:
Subject: nested inner join help
Next
From: "Kevin Zapico"
Date:
Subject: Result sets from functions