Question

求大神，关于sql查询的问题

select u.id_ as userId_,o.name_ as orgName_,p.name_ as postName_,u.name_,u.employeeno_ from fw_user u ,fw_post p,fw_organization o where u.postId_ = p.id_ and u.orgId_ = o.id_ and u.enable_ = 1这个语句怎么改，如果o.name_ as orgName_这个为空的情况也查出来

Answer 1

select u.id_ as userId_,o.name_ as orgName_,p.name_ as postName_,u.name_,u.employeeno_
from fw_user u join fw_post p on u.postId_ = p.id_
     left join fw_organization o on u.orgId_ = o.id_
where u.enable_ = 1

Answer 2

lz试试看，有问题再追问。
select u.id_ as userId_,
o.name_ as orgName_,
u.postName_,
u.name_,
u.employeeno_ 
from 
fw_organization o 
left join 
(select p.name_ as postName_,
 u.name_,
 u.employeeno_
 from fw_user u ,fw_post p
 where u.postId_ = p.id_
 and u.enable_ = 1)u
on u.orgId_ = o.id_