joining 3 tables

alski · #1 (**permalink**) 09-13-11, 18:16

I have 3 tables:

'manager'
manager_id
manager_name

'manager_business'
manager_id
business_id

'business'
business_id
business_brand

If I type in the manager name, I would like to see which business_brands he/she manages.

I am halfway there with this statement:

SELECT manager_name, business_id
FROM manager
LEFT JOIN manager_business ON manager.manager_id = manager_business.manager_id
where manager_name like '%john%'

Any help?

alski · #2 (**permalink**) 09-13-11, 18:36

I may have answered my question, although there maybe a better way:

select manager_name, business_brand from manager, business, manager_business where manager.manager_id = manager_business.manager_id and manager_business.business_id = business.business_id and manager_name like '%john smith%'

r937 · #3 (**permalink**) 09-14-11, 06:24

voila, the better way --

Code:

SELECT manager.manager_name
     , business.business_brand 
  FROM manager
INNER
  JOIN manager_business 
    ON manager_business.manager_id = manager.manager_id
INNER
  JOIN business
    ON business.business_id = manager_business.business_id
 WHERE manager.manager_name LIKE '%john smith%'

Internet Services

Web Development

Digital Marketing

Consumer Tech