Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 58A792E2F32 for ; Fri, 25 Jan 2008 12:11:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 61757-08 for ; Fri, 25 Jan 2008 12:11:55 -0400 (AST) Received: from web63009.mail.re1.yahoo.com (web63009.mail.re1.yahoo.com [69.147.96.220]) by postgresql.org (Postfix) with SMTP id E0A8A2E2FCB for ; Fri, 25 Jan 2008 12:11:54 -0400 (AST) Received: (qmail 54868 invoked by uid 60001); 25 Jan 2008 16:11:53 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.ca; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=VtOxh2w+uWyeWl5Gm9QNWRafa41acbJvMG2J+n06p24bTlThjDf5lyKpFFuZtaRk+fAQwidrdYbCG7rNccMmsGprqgeOQvxRl30Fmg3Mk/fTsexnkNwLmi9ixGHbZ9HGTjuttypElZ+x5b0oyZni8zmCSPyYgmzoQGM0Nsz8vws=; X-YMail-OSG: VBJvhl0VM1mj4Fp6a8oG_ePiTHbI63d4UD4hwPVF Received: from [66.46.85.2] by web63009.mail.re1.yahoo.com via HTTP; Fri, 25 Jan 2008 11:11:53 EST Date: Fri, 25 Jan 2008 11:11:53 -0500 (EST) From: acec acec Subject: This SQL works under Mysql, not Postgresql. To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <692719.53428.qm@web63009.mail.re1.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/191 X-Sequence-Number: 30044 I have the following sql, which works fine under mysql database: SELECT sa.ID, suv.TOTAL as VOICE_TOTAL, sus.TOTAL as SMS_TOTAL FROM SUB_ACCOUNT sa INNER JOIN SUBSCRIBER s ON (sa.ID = s.SUB_ACCOUNT_ID) LEFT JOIN (SERVICE suv, SERVICE sus) ON (sa.ID = suv.SUB_ACC_ID AND suv.SERVICE_ID = 0 AND sa.ID = sus.SUB_ACC_ID AND sus.SERVICE_ID = 1) WHERE s.TELEPHONE = '111111111'; When I ran it under postgresql, which gave me "ERROR: syntax error at or near" It looks like I could not put two table on LEFT JOIN: LEFT JOIN (SERVICE suv, SERVICE sus) Do you have any suggestion for this problem? Thanks in advance. Looking for the perfect gift? Give the gift of Flickr! http://www.flickr.com/gift/