linking two tables (should be simple!!)

[englishnewbie]

meanwhile (and i'll probably post this as a new thread!):

i have two tables: company and people.

The link is the company field, which is text, a company name.

I've put these two tables together separately, importing the data.

I want to create a relationship between company field in one and company field in the other.
But, having done so, there seems to be no link.

I REALLY don't want to have to do these 500 entries manually, so what's wrong? 300 or so should match.....

thanks, neil

 

[Golom]

Your SQL needs a FROM clause like

FROM Company INNER JOIN People ON Company.Company = People.Company