in LandaV8: Specify the Person in which department ~!

Select * from(

(select VGUID,ODESC as DESC0,ODESCCHS as DESC1,PGUID,OID as ZORDER from CSORGA_1 where VGUID in ('8E7B0EE5-F625-4202-B3DD-A2EAED2A673D','EA934841-142C-4E7C-A610-D627C76739CB') )union

 (select VGUID,DCNAME as DESC0,DCNAMECHS as DESC1,DCDEPT as PGUID,DCNO as ZORDER FROM CSEMPL_1 where DCDEPT in

 ('EA934841-142C-4E7C-A610-D627C76739CB'))

)A ORDER BY ZORDER

 

 

 

 

 

on the top ,we can find there have two vguid in the CSORGA_1 tabel ,

becauses we should bring the up company name ,

so there will be one more vguid in the sentence ~!

and there is one more vguid in the CSEMPL_1 tabel ,

it will bring the person which in the department ~!