Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA7Gn7m12819 for ; Wed, 7 Nov 2001 11:49:07 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.7) with HTTP id 500809; Wed, 07 Nov 2001 08:49:10 -0800 From: "Josh Berkus" Subject: Re: RIGHT JOIN is only supported with mergejoinable join To: , "PGSQL-SQL" X-Mailer: CommuniGate Pro Web Mailer v.3.4.7 Date: Wed, 07 Nov 2001 08:49:10 -0800 Message-ID: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Archive-Number: 200111/108 X-Sequence-Number: 5492 Nick, > RIGHT JOIN is only supported with mergejoinable join conditions Woof! Talk about destruction testing. You have ... let's see ... a three-column right join on two right-joined tables. If you ahve uncovered a bug, I wouldn't be surprised. However, are you sure you want RIGHT OUTER JOINS and not LEFT? Try re-organizing the query as LEFT JOINS, and see if it works. create view demo as      select        case_data.case_id,        case_disposition_code.case_disp_global_desc,        local_case_type.global_case_type_desc      from        ( case_data          left join case_disposition_code          on          case_data.case_disp_local_code =          case_disposition_code.case_disp_local_code        ) LEFT JOIN local_case_type ON        ((          local_case_type.court_id =          case_data.court_id        )        and        (          local_case_type.local_case_subtype_code =          case_data.local_case_type_code        )        and        (          local_case_type.local_case_subtype_code =          case_data.local_case_subtype_code        )); If that doesn't work, try making the case_data and case_disposition_code join into a subselect. -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