17,089
社区成员
发帖
与我相关
我的任务
分享
select NEW_YGINFO.YGID,NEW_DEPT.DEPTNAME,NEW_YGINFO.YGNAME,NEW_DEPTGW.DEPT_GW,NEW_YGINFO.YGSFZ,NEW_YGINFO.LOGINNAME,NEW_YGINFO.ROLE,NEW_YGINFO.PASSWORD,count(*) from new_yginfo inner join new_dept on new_yginfo.deptid = new_dept.id inner join new_deptgw on NEW_DEPTGW.DEPT_GWID = NEW_DEPT.ID
select
NEW_YGINFO.YGID,
NEW_DEPT.DEPTNAME,
NEW_YGINFO.YGNAME,
NEW_DEPTGW.DEPT_GW,
NEW_YGINFO.YGSFZ,
NEW_YGINFO.LOGINNAME,
NEW_YGINFO.ROLE,
NEW_YGINFO.PASSWORD,
count(*)from new_yginfo , new_dept, NEW_DEPTGW
where new_depton new_yginfo.deptid = new_dept.id
and
new_deptgw on NEW_DEPTGW.DEPT_GWID = NEW_DEPT.ID
inner join new_deptgw
on NEW_DEPTGW.DEPT_GWID = NEW_DEPT.ID