Received: from shire.ontko.com (shire.ontko.com [199.164.165.1]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA7GIOm11711 for ; Wed, 7 Nov 2001 11:18:24 -0500 (EST) (envelope-from nickf@ontko.com) Received: from nick (bilbo.ontko.com [199.164.165.101]) by shire.ontko.com (8.9.3/8.9.3/Debian 8.9.3-21) with SMTP id LAA27377 for ; Wed, 7 Nov 2001 11:18:28 -0500 X-Authentication-Warning: shire.ontko.com: Host bilbo.ontko.com [199.164.165.101] claimed to be nick Reply-To: From: "Nick Fankhauser" To: "PGSQL-SQL" Subject: RIGHT JOIN is only supported with mergejoinable join conditions Date: Wed, 7 Nov 2001 11:16:38 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Importance: Normal X-Archive-Number: 200111/105 X-Sequence-Number: 5489 Hi- I'm on version 7.1, and I'm getting this error when attempting to select from a view: RIGHT JOIN is only supported with mergejoinable join conditions I don't understand what this error is telling me... The script I have used to create the view is below pasted in below. Essentially, I have a main table which I want to see every row from. I also have two separate lookup tables that I want to get a description field from *if* there is a matching code in a corresponding nullable field in the main table. I tried pasting this into MSAccess, and it works fine there. (I know this doesn't necessarily mean it is valid SQL .) My questions are: 1)Have I done something wrong here, or am I hitting a limitation of PostgreSQL? 2)In either case, how could I re-write this to make it work with PostgreSQL? Thanks! -Nick create view demo as select case_data.case_id, case_disposition_code.case_disp_global_desc, local_case_type.global_case_type_desc from local_case_type right join ( case_disposition_code right join case_data on case_disposition_code.case_disp_local_code = case_data.case_disp_local_code ) 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 ); -------------------------------------------------------------------------- Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/