Re: SQL : left join from multiple tables

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 ______________________________________