Re: This SQL works under Mysql, not Postgresql.
| От | Oliveiros Cristina |
|---|---|
| Тема | Re: This SQL works under Mysql, not Postgresql. |
| Дата | |
| Msg-id | 012101c85f72$b92ca380$ec5a3d0a@marktestcr.marktest.pt обсуждение исходный текст |
| Ответ на | This SQL works under Mysql, not Postgresql. (acec acec <tomcatacec@yahoo.ca>) |
| Список | pgsql-sql |
Neither have I.
The LEFT JOIN I know is something like
SELECT ...
FROM table1
LEFT OUTER JOIN table2
ON ....
Try using this construct
Best,
Oliveiros
----- Original Message -----
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "acec acec" <tomcatacec@yahoo.ca>
Cc: <pgsql-sql@postgresql.org>
Sent: Friday, January 25, 2008 4:23 PM
Subject: Re: [SQL] This SQL works under Mysql, not Postgresql.
>> 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...
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
В списке pgsql-sql по дате отправления: