From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | "acec acec" <tomcatacec(at)yahoo(dot)ca> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: This SQL works under Mysql, not Postgresql. |
Date: | 2008-01-25 16:23:53 |
Message-ID: | dcc563d10801250823p3694ee4flc5029b93594ecf66@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Jan 25, 2008 10:11 AM, acec acec <tomcatacec(at)yahoo(dot)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...
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-01-25 16:29:30 | Re: regex_replace problem -additional |
Previous Message | Gary Stainburn | 2008-01-25 16:19:43 | Re: regex_replace problem -additional |