T
Theleepan
Hi! i need help on left outer join! when i use two table and with outer join
it works. i want to know if i could use another table (t3) wich i don't need
any outer join, just to import the table where i could use it WHERE
statement. i get an errror msg. i don't know how to import it. i tried before
and after the outer join statement. but its not working. please help. thanks!
select *
from t1
left outer join t2
on t1.name=t2.name
where t1.number = t2.number
this thing is working fine.
select *
from t3, t1
left outer join t2
on t1.name=t2.name
where t1.number = t2.number
t3.number = t1.number
t3.number = t3.number
it works. i want to know if i could use another table (t3) wich i don't need
any outer join, just to import the table where i could use it WHERE
statement. i get an errror msg. i don't know how to import it. i tried before
and after the outer join statement. but its not working. please help. thanks!
select *
from t1
left outer join t2
on t1.name=t2.name
where t1.number = t2.number
this thing is working fine.
select *
from t3, t1
left outer join t2
on t1.name=t2.name
where t1.number = t2.number
t3.number = t1.number
t3.number = t3.number