查询公司职工数sql语句:
select umOrg.*,(select count(0) from umStaff where bcfl like umOrg.id+'%') as ProNum from umOrg where umOrg.bcfl='0'错误
umOrg
ID Name
1 A公司
101 技术部umStaff
ID bcfl Name
1 1/101 testtest是A公司技术部的
select umOrg.*,(select count(0) from umStaff where bcfl like umOrg.id+'%') as ProNum from umOrg where umOrg.bcfl='0'错误
umOrg
ID Name
1 A公司
101 技术部umStaff
ID bcfl Name
1 1/101 testtest是A公司技术部的
select umOrg.*,(select count(0) from umStaff where bcfl Like Concat(umOrg.id,'%')) as ProNum from umOrg where umOrg.bcfl='0'
as ProNum from umOrg where umOrg.bcfl='0'