J
Jaymus
Guest
Hi, I need some help with putting together a results that involves two different tables.
Say Both Tables have a common Field - Company Name
Table 1 has a less records with only one field - Company Name
Table 2 has a longer list with TWO fields - Company Name and City
The Company Names are similar in both tables
but I would like to display the results with Company name from BOTH Tables and Any cities associated with the name from table 1
Problem is that ie AT&T in table 1 won't link up to AT&T International in Table 2.
I know I can use the Like * wildcard but how do I link the two tables with the criteria of table 1 to find similar companies
Tables1
Company Name
AT&T
Table2
Company Name City
AT&T International Palo Alto
AT&T International London
AT&T Coporate London
Sorry if I sound very confusing, but my main questions is I suppose:
How do I write a query to find Similar * Company Names between two Tables
Thank you for any help you can provide.
Jaymus
[This message has been edited by Jaymus (edited 07-24-2001).]
Say Both Tables have a common Field - Company Name
Table 1 has a less records with only one field - Company Name
Table 2 has a longer list with TWO fields - Company Name and City
The Company Names are similar in both tables
but I would like to display the results with Company name from BOTH Tables and Any cities associated with the name from table 1
Problem is that ie AT&T in table 1 won't link up to AT&T International in Table 2.
I know I can use the Like * wildcard but how do I link the two tables with the criteria of table 1 to find similar companies
Tables1
Company Name
AT&T
Table2
Company Name City
AT&T International Palo Alto
AT&T International London
AT&T Coporate London
Sorry if I sound very confusing, but my main questions is I suppose:
How do I write a query to find Similar * Company Names between two Tables
Thank you for any help you can provide.
Jaymus
[This message has been edited by Jaymus (edited 07-24-2001).]