Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1654Ex12439 for ; Tue, 6 Feb 2001 00:04:14 -0500 (EST) (envelope-from pgsql-general-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f12503q19558; Fri, 2 Feb 2001 00:00:03 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f124cip39247; Thu, 1 Feb 2001 23:38:44 -0500 (EST) (envelope-from news) From: Ian Harding X-Newsgroups: comp.databases.postgresql.sql, comp.databases.postgresql.general, comp.databases.postgresql.novice Subject: Re: SQL Join - MySQL/PostgreSQL difference? Date: Thu, 01 Feb 2001 20:45:00 -0800 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 49 Message-ID: <3A7A3B4C.856EC9EF@pakrat.com> References: <3A79E9E8.238F653B@webprojkt.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: scrappy@hub.org X-Mailer: Mozilla 4.61 [en] (X11; U; Linux 2.2.12-20 i686) X-Accept-Language: en To: pgsql-general@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200102/190 X-Sequence-Number: 4036 Brice Ruth wrote: > Greetings. > > I'm working with a product provided by a third part that interfaces to > data housed in a database of your choice. Previously, my choice was > MySQL - apparently it handled certain queries too slowly, so I'm giving > PostgreSQL a shot. Here's the query: > > SELECT > a.Number, > a.Code, > a.Text > FROM > b, > a > WHERE > (b.Id = a.Id) AND > (VersionId = 'key1') AND > (Category = 'key2') AND > (b.d_Id = 'key3') > ORDER BY > a.Number; > > (my apologies: I had to 'mangle' the table/column names because of NDA) > > So my question is this: would this query operate differently in MySQL > than in PostgreSQL? The reason I ask is that this query in MySQL > returns results, yet in PostgreSQL it does not. I read a post about > PostgreSQL not supporting outer joins, but I don't have enough > experience with SQL to determine if this is such a query or not. Please > > advise. > > Any help will be (as always) sincerely appreciated. > > -- > Brice Ruth > WebProjkt, Inc. > VP, Director of Internet Technology > http://www.webprojkt.com/ It should work the same in both. The only thing I notice is that not all the field names are qualified with table names or aliases. That can lead to ambiguity, but the query would blow up on both databases if that were a problem. Ian