select '1' as type,FL_ID,FL_CODE,FL_CNAME,FLDA.FL_PARENTID from FLDA WHERE ZT_ID=2006030002 union select '2' as type,XM_ID,XM_CODE ,XM_CNAME ,FL_ID from XMDA where exists (select * from (select FL_ID from FLDA WHERE ZT_ID=2006030002 ) a where XMDA.fl_id=a.fl_id) order by type,FL_PARENTID ,FL_ID