x27;Faisal Abdullah'; [EMAIL PROTECTED]
Subject: RE: [PHP] SQL : left join from multiple tables
[snip]
"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 s
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 woul
[snip]
[snip]
"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 i
[snip]
"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.
[/sn
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.departm
5 matches
Mail list logo
