RE: [PHP] Oracle 8i SQL Problem..
| From: | Rudolf Visagie | Date: | Mon, 29 Jul 2002 07:22:39 +0000 |
| Subject: | RE: [PHP] Oracle 8i SQL Problem.. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-110104@lists.php.net to get a copy of this message | ||
Oracle 9i would be happy with the left join syntax but not 8i.
-----Original Message-----
From: Martin Towell [mailto:martin.towell@world.net]
Sent: Monday, July 29, 2002 6:09 AM
To: 'Nick Oostveen'; Frank S. Kicenko; php-general@lists.php.net
Subject: RE: [PHP] Oracle 8i SQL Problem..
You'll prob. need to use the (+) to join
like this
SELECT grp.grpdescrip, grp.grp, grp.createcust, grp.auth1, grp.auth2,
usergrp.userid, users.userdescrip
FROM grp, usergrp, users
WHERE grp.grp = usergrp.grp (+)
AND usergrp.userid=users.userid (+)
ORDER BY grp.grp
-----Original Message-----
From: Nick Oostveen [mailto:nicko-ml@hpmarketing.com]
Sent: Monday, July 29, 2002 1:47 PM
To: Frank S. Kicenko; php-general@lists.php.net
Subject: Re: [PHP] Oracle 8i SQL Problem..
I could be wrong on this but I believe that Oracle 8i uses a proprietary
join syntax. This support has been added in the latest version of Oracle,
but with 8i I believe you're out of luck using the left join keywords.
Check out
http://certcities.com/certs/oracle/columns/story.asp?EditorialsID=106
for
more info on this.
At 10:26 AM 7/28/2002 -0500, Frank S. Kicenko wrote:
>Hi,
>This really isn't a PHP issue..sorry.
>
>I'm having a nightmare with Oracle 8i (pos!). I'm writing common SQL
>which works for MSSQL 2K and seems correct for Oracle... but keeps
>giving me a Error.. ORA-00933 SQL command not properly ended on the
>following query...
>
>SELECT grp.grpdescrip, grp.grp, grp.createcust, grp.auth1, grp.auth2,
>usergrp.userid, users.userdescrip
> FROM grp
> LEFT JOIN usergrp
> ON grp.grp=usergrp.grp
> LEFT JOIN users
> ON usergrp.userid=users.userid
> ORDER BY grp.grp
>
>The error keeps pointing at the first "LEFT JOIN". Anybody know why?
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php