Home -> Usenet -> comp.databases.oracle -> Re: A query question

Re: A query question

From: crappy <crappygolucky_at_hotmail.com>
Date: 4 Jan 2002 11:01:27 -0800
Message-ID: <ce31c410.0201041101.78e33c5b_at_posting.google.com> 







uhh, judging from your attempt maybe i don't really understand the
problem, but why can't you just do:



select ssn, name, custid from table a, table b where a.ssn = b.ssn and
a.name = b.name and a.custid != b.custid;



?
Received on Fri Jan 04 2002 - 20:01:27 CET












Original text of this message