Re: SQL Syntax Queestion
From: Matt Brennan <mbrennan_at_gers.antispam.com>
Date: Wed, 10 Jun 1998 20:06:59 GMT
Message-ID: <01bd94ab$4f423760$049a0580_at_mcb>
Date: Wed, 10 Jun 1998 20:06:59 GMT
Message-ID: <01bd94ab$4f423760$049a0580_at_mcb>
D'oh! I stand corrected...
-- Matt Brennan SQL*Tools Specialist GERS Retail Systems 9725-C Scranton Road San Diego, California 92121 1-800-854-2263 mbrennan_at_gers.com (Original email address is spam-blocked.) Mars <mars_at_writeme.com> wrote in article <6lmkrg$aoj$1_at_cadmium.aware.nl>...Received on Wed Jun 10 1998 - 22:06:59 CEST
> you forgot the jion of anothertable;
>
> Select * from
> Households
> where Households.LastName||Households.FirstName IN
> (Select LastName||FirstName from AnotherTable
> where LastName||FirstName = Households.LastName||Households.FirstName
> having count (LastName||FirstName) > 1
> group by LastName||FirstName);