Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to combine tables
This should do the trick
create view exal_test
as select p.prod_no, p.prod_desc, p.model_no, s.qty_av
from product p, stock s
where p.prod_no = s.prod_no(+)
union
select p.prod_no, p.prod_desc, p.model_no, s.qty_av
from product p, stock s
where p.prod_no(+) = s.prod_no;
Regards
/Joachim
Received on Thu Nov 12 1998 - 00:00:00 CST