select tr_code, GetFieldNames('absys_org_treeitem','Ti_name;PubID')
from ABSys_Org_Tree left join absys_org_treeitem on tr_guid =ti_tr_guid
GetFieldNames('absys_org_treeitem','Ti_name;PubID')意思是absys_org_treeitem表中除Ti_name;PubID这两个字段外的其它字段
select tr_code, GetFieldNames('absys_org_treeitem','Ti_name;PubID')
from ABSys_Org_Tree left join absys_org_treeitem on tr_guid =ti_tr_guid
GetFieldNames('absys_org_treeitem','Ti_name;PubID')意思是absys_org_treeitem表中除Ti_name;PubID这两个字段外的其它字段