我的帐表项目，部门，个人同时查询语句：selectccode,iperiod,dbill_date,cdigest,cdept_id,cdepname,cperson_id,cpersonname,gl_accvouch.citem_class,citem_name,citem_id,citemname,md,mcfromgl_accvouchleftjoinDepartmentonDepartment.cdepcode=cdept_idleftjoinpersononperson.cpersoncode=cperson_idleftjoin(SELECT'98'AScItem_Class,'现金流量项目'AScItem_Name,tItem.citemcode,tItem.citemnameFROMfitemss98tItemUNIONALLSELECT'97'AScItem_Class,'项目管理'AScItem_Name,tItem.citemcode,tItem.citemnameFROMfitemss97tItemUNIONALLSELECT'00'AScItem_Class,'报销项目'AScItem_Name,tItem.citemcode,tItem.citemnameFROMfitemss00tItemUNIONALLSELECT'01'AScItem_Class,'网上报销'AScItem_Name,tItem.citemcode,tItem.citemnameFROMfitemss01tItem)ascitemoncitem.citem_class=gl_accvouch.citem_classandcitem.citemcode=gl_accvouch.citem_id
