[Solved] Retrieve records from Multiple tables using Join

by


I made the assumption that this is SQL Server and it didn’t look like there was a where clause requirement so I provided this query for that. If you need for mysql please update question.

 Select co.com_name,c.c_name,b.b_id,b.b_name
 from Country c
 inner join Company co on c.c_id = co.c_id
 inner join branch b on co.com_id = b.com_id

solved Retrieve records from Multiple tables using Join