การรวมข้อมูลให้อยู่แถวเดียวกัน โดยมีสองเงื่อนไข (SQL SERVER)

Select '8008008' as MachineID,BillNumber,Amount as GTO1,PaymentType As Pay1,0 as GTO2,0 as Pay2
From TempWCN_CNPW
Where Line = 1
UNION ALL 
Select '8008008' as MachineID,BillNumber,0 as GTO1,0 As Pay1,Amount as GTO2,PaymentType As Pay2
From TempWCN_CNPW
Where Line = 2

8008008	 MVLWB000009	17	2	 0	0
8008008	 MVLWB000009	0	0	50	1

8008008	MVLWB000009	17	2	50	1