Faisal, 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.
HTH Chris 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