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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Multi-query simplification

Re: Multi-query simplification

From: joachim Carlsson <joachim.carlsson_at_neurope.ikea.com>
Date: 1998/01/13
Message-ID: <69fged$huj$1@mailgate.ikea.com>#1/1

This doesn't look very good.

Should be like
select distinct data from
a, b
where a.key1 = b.key1
and b.key2 = b.key2;

or use group by..

/Joachim Received on Tue Jan 13 1998 - 00:00:00 CST

Original text of this message

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