Left join in Oracle 8i (8.1.7)

RRR
RRR used Ask the Experts™
on
Hi, Experts.
I need to select data from two tables with left join.
Please, paste me the syntax of PL/SQL that I can run in SQL Plus.


Thanks, RRR.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
select A.col1, A.col2, B.col1, B.col2
  from table_one A, table_two B
  where a.col1 = b.col1(+) ;

Returns all the rows of Table_One, even if no rows match in Table_Two

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial