SELECT TOP 500
	Service.Voucher_Number,
        Service.Service_Date_From, 
        Service.Procedure_Code,
	--
        Patient.Patient_Number, 
        Patient.Patient_First_Name, 
        Patient.Patient_Last_Name, 
	--
	Payment.Transaction_Type,
        Payment.Transfer_To_Carrier_Abbr
FROM
	Ntier_Training.PM.vwGenSvcInfo		Service,
	Ntier_Training.PM.vwGenPatInfo		Patient,
	Ntier_Training.PM.vwGenSvcPmtInfo	Payment
WHERE
	Patient.Patient_ID = Service.Patient_ID
  AND	Payment.Service_ID = Service.Service_ID
ORDER BY
	Service.Voucher_Number;