find matches 1

[pooterpooter]

Is there a way in Access to find matches in the company
names between 2 tables that are not related?
My first table consists of the following fields:
CustomerID - the field is autonumber
CompanyName


The second tables cosnsits of the folowing fields:
ContactID the field is autonumber
CompanyName

I want to make a query enumerating only those customers and
contacts, which COmpaneName is the same.


For examplem:


CustomerID companyname contactID companyName

142 Fenchel 35 Fenchel

There was a wizard in the query for find matched query but
my programme cannot use it.
Could you help me with an sql, if my wish is possible at

all?

 

[Remou]

Hi
In the query window you can drag one company name to the other to create a join. This will show up company names that are the same, but you need to be careful because you could have Fenchel Ltd in one and Fenchel Limited in the other. Then there is Pooter of 1 Main Street and Pooter of 2 North Street, not to mention misspelling etc.

In SQL view you will see something like:
[tt]SELECT Contacts.Company, Customers.Company
FROM Contacts INNER JOIN Customers ON Contacts.Company = Customers.Company;[/tt]