Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Can I have left join or right join in Oracle?
The LEFT JOIN and the similar RIGHT JOIN operations can be used in any FROM clause to combine records from two tables. The LEFT JOIN operation is used to create a left outer join and includes all of the records from the first (left) of the two tables, even if there are no matching values for records in the second. The RIGHT JOIN operation is used to create a right outer join and includes all of the records from the second (right) of the two tables, even if there are no matching values for records in the first. (http://www.devguru.com/index.asp?page=/Technologies/jetsql/quickref/leftjoi n.html)
from table_a a, table_b b
where a.common = b.common(+) -- left join
or
where a.common(+) = b.common -- right join
"Carfield Yim" <carfield_at_programmer.net> wrote in message
news:399FE394.EF81A05B_at_programmer.net...
> Can I have left join or right join in Oracle?
>
Received on Mon Aug 21 2000 - 10:30:04 CDT