Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5SMdKa75556 for ; Thu, 28 Jun 2001 18:39:20 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.1) with HTTP id 78831; Thu, 28 Jun 2001 15:39:16 -0700 From: "Josh Berkus" Subject: Re: Still stuck on a left join To: Cc: pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Thu, 28 Jun 2001 15:39:16 -0700 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200106/460 X-Sequence-Number: 3763 Ari, > I've been stuck now on a left join for about two weeks. DB is > MSaccess2K, > language is ASP. I'm learning php and PgSQL now, and will be > migrating > everything soon. In the mean time. If anyone knows where I am going > wrong, > please let me know. Shame on you! Seriously, you'd probably spend less time learning how to use PostgreSQL than on getting around Access2k's "features." One of these "features" is a fussy query optimizer that frequently rejects perfectly valid query strings. This is why I charge my clients $40/hour more to work with Access2k. Try monkeying with the parentheses in the JOIN expression: (a LEFT OUTER JOIN b ON a.1 = b.1) LEFT OUTER JOIN c ON b.2 = c.1 .. may work, where ... a LEFT OUTER JOIN b ON a.1 = b.1 LEFT OUTER JOIN c ON b.2 = c.1 ... does not. Also try it without aliasing the tables. If you need further help with MS Access, give me a call ... but I charge hourly for Microsoft stuff! -Josh ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco