select t.uuid,t.emp_name,t.emp_sex from bcot_emp_info t left join (select u.value from bcot_pcood u where u.key in (select t.nation from bcot_emp_info t)and u.type_code='MZ') left join (select u.value from bcot_pcood u where u.key in (select t.emp_zzmm_code from bcot_emp_info t)and u.type_code='ZZMM')
一直提示是缺少关键字是怎么回事 ，我写的不对 吗？
------解决思路----------------------
t1 left jion t2 on t1.x=t2.x
------解决思路----------------------
t1 left jion t2 on t1.x=t2.x
left jion t3 on t1.x=t3.x
------解决思路----------------------
join与on是配合的，没有on的join语句不对