I'd check the documentation CDs for Oracle 9i. Oracle 8 does not use the 
"join" or "left" keywords but a plus sign in parenthesis "(+)" whose 
position determines whether it is a left or right join. It may not be 
SQL2 but its Oracle.


Marek Kilimajer wrote:

> Well, this would work in MySQL, I have even more LEFT JOINs, so go 
> find out if it is possible with Oracle.
> Faisal Abdullah wrote:
>> Hi again people! How's it goin?
>> Here's the question
>> How do I do left joins from multiple tables?
>> I want to do something like this:
>> "select a.name, b.department, c.position
>> from emp a
>> left join dept b
>> on a.staffno = b.staffno
>> left join position c
>> on a.staffno = c.staffno
>> where staffno = $staffno";
>> I know the statement above is totally wrong. I'm just hoping u guys can
>> understand what i'm trying to achieve from it.
>> By the way, this is on Oracle 9i, but I guess ANSI would be fine.
>> Thanks again.
>> Sincerely,
>> Faisal
>> ______________________________________

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to