Compairing two tables t-sql
Posted on 2008-06-09
I have a table that holds data on address information,it also has a column which shows what type of product is on the address.
This table has been created based on a coverage db ,and now i would like to compare this table to my own database.
My own db has address information and information on clients and products.
I would like to show all the information from the coverage table and show how many of these address compare to the address in my db .
I tried using INTERSECT and just plain joins but because there could be one address line in my db that has the same address lines it seems to return duplicate rows...
Please can some one give me some advice on this.