Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g08LRhB76973 for ; Tue, 8 Jan 2002 16:27:43 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id g08LGao62421 for pgsql-sql@postgresql.org; Tue, 8 Jan 2002 16:16:36 -0500 (EST) (envelope-from news) From: tjennette@thomasnelson.com (Trace) X-Newsgroups: comp.databases.postgresql.sql Subject: SQL Joins Date: 8 Jan 2002 13:16:28 -0800 Organization: http://groups.google.com/ Lines: 36 Message-ID: <56893385.0201081316.25272d8c@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200201/120 X-Sequence-Number: 6209 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