##環境 MySQL 5.5.20
##SQL //NG select m.id as i_on_m, m.name as n_on_m, m.company_id as ci_on_m , cnt.id as i_on_cnt, cnt.name as n_on_cnt , cmp.id as i_on_cmp, cmp.name as n_on_cmp, cmp.country_id as ci_on_cmp from members m inner join countries cnt on cmp.country_id = cnt.id left join companies cmp on m.company_id = cmp.id order by m.id //OK select m.id as i_on_m, m.name as n_on_m, m.company_id as ci_on_m , cnt.id as i_on_cnt, cnt.name as n_on_cnt , cmp.id as i_on_cmp, cmp.name as n_on_cmp, cmp.country_id as ci_on_cmp from members m left join companies cmp on m.company_id = cmp.id inner join countries cnt on cmp.country_id = cnt.id order by m.id