The table design should be tweaked. In most cases, you don't want to have repetitive data in two different tables, in this case, your Company Name field. Table 2 should reference the unique values in Table 1, that is, the Company ID.
Tweak Table 2 People:
Company_ID (data should match any value in Companies.company_id)
If you're designing a front end app, then good design should force the user to choose only those valid company names from the Company table, without having to actually validate it by the time it gets to the back end.
When you're ready to pull the data, you'll have to do a join against the two tables WHERE Company.Company_ID = People.Company_ID, but you can figure that out yourself!
Just something to chew on - make sure to have a plan if you have people connected to a company, but you want to delete the company.