56,677
社区成员
发帖
与我相关
我的任务
分享
select
ifnull((select departName from oa_department where departID = userinfo.departID and departType = 1),'无') as bm,
ifnull((select departName from oa_department where departID = userinfo.departID and departType = 2),'无') as ks,
ifnull((select departName from oa_department where departID = userinfo.departID and departType = 3),'无') as bz,
userName,
realName
from oa_sys_userpost as userinfo group by userinfo.userID
select
if null((select departName from oa_department where departID = userinfo.deparID and departType = 1),'无') as bm,
if null((select departName from oa_department where departID = userinfo.deparID and departType = 1),'无') as ks,
if null((select departName from oa_department where departID = userinfo.deparID and departType = 1),'无') as bz,
userName
from oa_sys_userpost as userinfo group by userinfo.userID
我是按照博主的这样写的,可是数据库提示的错误信息如下:
[SQL] select
if null((select departName from oa_department where departID = userinfo.deparID and departType = 1),'无') as bm,
if null((select departName from oa_department where departID = userinfo.deparID and departType = 1),'无') as ks,
if null((select departName from oa_department where departID = userinfo.deparID and departType = 1),'无') as bz,
userName
from oa_sys_userpost as userinfo group by userinfo.userID
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null((select departName from oa_department where departID = userinfo.deparID an' at line 2