Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (Postfix) with ESMTP id 86BAE4758A2 for ; Wed, 17 Apr 2002 00:32:36 -0400 (EDT) Received: from [63.195.55.98] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.5.9) with HTTP id 1373695; Tue, 16 Apr 2002 21:32:40 -0700 From: "Josh Berkus" Subject: Re: help - JOIN problem To: chief_87@yahoo.com (KeithR), pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.5.9 Date: Tue, 16 Apr 2002 21:32:40 -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: 200204/203 X-Sequence-Number: 7467 Keith, > I have 3 tables; USER, ACCESS_PATH, and ACCESS (All of the > generation scripts are at the end). USER contains users information, > ACCESS_PATH contains a URL and an ID, and ACCESS contains USER ids > and > ACCESS ids No, your problem is that you are using Microsoft SQL Server and not PostgreSQL. This is a PostgreSQL list. If you insist on using MS SQL Server, your troubles are your own. I'd suggest that you join a list for the database you are actually using. -Josh Berkus