DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=xCgaW5C04Mvl3mkUv7frO+zShu3np93oCgTwH2FRgVPLtmym0EQgKHjWszEzm44dt0r8/5iJkynPTUdjjd9g209zOpJBKaioPzp6BpWWbdl9vgmUoQn7csjcXVlKtThdq303P/PSbe5u5Efn36k+cPzdklWlLs8fUbcQS76zak4=
Message-ID: <dcc563d10801250823p3694ee4flc5029b93594ecf66@mail.gmail.com>
Date: Fri, 25 Jan 2008 10:23:53 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "acec acec" <tomcatacec@yahoo.ca>
Subject: Re: This SQL works under Mysql, not Postgresql.
Cc: pgsql-sql@postgresql.org
In-Reply-To: <692719.53428.qm@web63009.mail.re1.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <692719.53428.qm@web63009.mail.re1.yahoo.com>

On Jan 25, 2008 10:11 AM, acec acec <tomcatacec@yahoo.ca> wrote:
> 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?

Is that legal SQL?  I've never seen anything like that before...