?!H

[Lafor]

I have 2 tables with FName LName Address, City
Want to see whether one is a subset of the other

select count(*)
from firsttable
where Rtrim(Ltrim(Upper(LName))) + " " + Rtrim(Ltrim(Upper(FName))) + " " + Rtrim(Ltrim(Upper(Address1))) + " " + Rtrim(Ltrim(Upper(City)))
in (select
Rtrim(Ltrim(Upper(LName))) + " " + Rtrim(Ltrim(Upper
(FName))) + " " + Rtrim(Ltrim(Upper(Address1))) + " " +
Rtrim(Ltrim(Upper(City)))

from secondtblSingularsExtracted)

No primary key or anything..

How can we speed this up??

Any ideas welcome

[Bigley]

Just a thought, because it's hard to be sure without dabbling with this one, but how about Selecting count(*) from the first table and then use a large Left Outer Join that joins the 2 tables on FName LName Address, City - that is if you are using SQL..........?

[paulw]

Check the record counts of both tables and then do a UNION query - If the record count is no bigger than either table then one is a super set of the other. That may be quicker, depends on your data.

Also index the tables - it will speed it up.

Cheers,

Paul.

[Lafor]

Thanks to all...