Skip site navigation (1) Skip section navigation (2)

Re: This SQL works under Mysql, not Postgresql.

From: acec acec <tomcatacec(at)yahoo(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: This SQL works under Mysql, not Postgresql.
Date: 2008-01-25 16:42:21
Message-ID: 979861.91164.qm@web63015.mail.re1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-sql
Maybe it is not legal sql according to SQL standard,
but it works under mysql, I try to port it into
Postgresql.

--- Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:

> 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...
> 



      Connect with friends from any web browser - no download required. Try the new Yahoo! Canada Messenger for the Web BETA at http://ca.messenger.yahoo.com/webmessengerpromo.php

In response to

pgsql-sql by date

Next:From: Oliveiros CristinaDate: 2008-01-25 16:52:51
Subject: Re: This SQL works under Mysql, not Postgresql.
Previous:From: Scott MarloweDate: 2008-01-25 16:32:22
Subject: Re: This SQL works under Mysql, not Postgresql.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group