RE: Help with a query

Quoting [EMAIL PROTECTED]: > > Sounds like you want to do: > > Select store_name, t1mgr.manager_name as 'type_1_manager', > t2mgr.manager_name as 'type_2_manager' > >From (keystone_stores ks left join managers t1mgr on ks.id = > t1mgr.store_id > and t1mgr.manager_type = 1) > Left join managers t2

Help with a query

Suppose I have two tables like this: keystone_storesmanagers = id | store_nameid | manager_name | manager_type | store_id +--- +---+---