SELECT D.DEPTID,D.DEPTNAME,D.DEPTPARENTID,D1.DEPTNAME AS DEPTPARENTNAME,D.DEPTCODE,D.CURRENTNUM,D.DEPTPREDICTNNT,D.CREATDATETIME,D.DESCRIBE,D.COMPINFOID,C.COMPINFONAME
FROM DEPARTMENT D,COMPANYINFO C,DEPARTMENT D1
WHERE D.COMPINFOID=C.COMPINFOID AND D.DEPTPARENTID=D1.DEPTID AND D.ALIVEFLAG=1
UNION
SELECT D.DEPTID,D.DEPTNAME,D.DEPTPARENTID,C.COMPINFONAME AS DEPTPARENTNAME,D.DEPTCODE,D.CURRENTNUM,D.DEPTPREDICTNNT,D.CREATDATETIME,D.DESCRIBE,D.COMPINFOID,C.COMPINFONAME
FROM DEPARTMENT D,COMPANYINFO C
WHERE D.COMPINFOID=C.COMPINFOID AND D.DEPTPARENTID='0' AND D.ALIVEFLAG=1
SELECT D.DEPTID,D.DEPTNAME,D.DEPTPARENTID,D1.DEPTNAME AS DEPTPARENTNAME,D.DEPTCODE,D.CURRENTNUM,D.DEPTPREDICTNNT,D.CREATDATETIME,D.DESCRIBE,D.COMPINFOID,C.COMPINFONAME
FROM DEPARTMENT D,COMPANYINFO C,DEPARTMENT D1
WHERE D.COMPINFOID=C.COMPINFOID AND D.DEPTPARENTID=D1.DEPTID AND D.ALIVEFLAG=1 AND DEPTNAME=''
UNION
SELECT D.DEPTID,D.DEPTNAME,D.DEPTPARENTID,C.COMPINFONAME AS DEPTPARENTNAME,D.DEPTCODE,D.CURRENTNUM,D.DEPTPREDICTNNT,D.CREATDATETIME,D.DESCRIBE,D.COMPINFOID,C.COMPINFONAME
FROM DEPARTMENT D,COMPANYINFO C
WHERE D.COMPINFOID=C.COMPINFOID AND D.DEPTPARENTID='0' AND D.ALIVEFLAG=1 AND DEPTNAME=''