select all from one table and select one field from another table

Hello

I have this query
SELECT * FROM reg_title_app f, agents a

how can I do something like this
SELECT * FROM reg_title_app f, agents a, company c
but only read one field from company?

I'm using mysql 4.0.27

Thanks,
Sean
sean-keysAsked:
Who is Participating?
 
Raynard7Commented:
Something like

Select f.*, a.*, c.Field FROM reg_title_app f, agents a, company c where f.id = a.id and a.id2 = c.id2
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
SELECT f.*, a.*, c.company_name FROM reg_title_app f, agents a, company c
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.