I don't understand joining using mysql so this may sound off...
I have 2 tables: example
id | name
1 | joe's pub
id | name | email | companyid
1 | joe | whatever | 1
I need to get the entire list from the 'people' table but I also need the name of the company they work for!???
All the things I've seen online join multiple tables in a strange way.