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>
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;
?