Ratakan

Informations :

SP untuk menampilkan PO Number, Receipt Number, Receipt Date

select distinct a.PONUMBER as 'PO Number',b.POPRCTNM as 'Receipt Number',b.receiptdate as 'Receipt Date' from POP10500 a
left join (select POPRCTNM,receiptdate from POP10300 
   union 
     select POPRCTNM,receiptdate from POP30300 ) b on a.POPRCTNM = b.POPRCTNM 

where a.PONUMBER <> ''





Hasilnya :


No comments