-
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
-
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..........?
-
UNION query
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.
-
...
