-
Hi,
can you help me to find the equivalent statement?
I have
select p.part_id, s.supplier_name
from part p, supplier s
where p.supplier_id = s.supplier_id (+);
the equivalent statement is
select p.part_id, s.supplier_name
from part p left outer join supplier s
on p.supplier_id = s.supplier_id;
or
select p.part_id,s.supplier_name
from supplier s right outer join part p
on s.supplier_id = p.supplier_id ;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|