How to Extract company name with all other info

[niladri20052006]

Hi All,

In Access I have two tables. The first one is records.raw where I have 5,00,000 data with multiple company names.

In another table2 I have only one column with unique company name (49,000).

waht I need is that I want the full info of in table2 from records.raw table.

As records raw is consisted of multiple contacts when I am trying to match with company names it is showing me all the companies.

Is there any way to get the all other info (like website, main phone, city, state etc. whcih are available in records.raw table) from records.raw table?

Thanks in advance!

 

[boblarson]

If you put both tables in the query and then link on company name, you can select all of the fields from the first table but it will only show the records for which a direct match on company name exists in the second table.