Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to combine tables

Re: How to combine tables

From: Joachim Carlsson <joachim.carlsson_at_neurope.ikea.com>
Date: 1998/11/12
Message-ID: <72eu1r$td2$1@mailgate.ikea.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US