select a.CustomerVehicleCode as VehicleCode, b.* from Process_Customer_Vehicle as a
inner join View_MemberSalesOrderHistory as b on a.CustomerVehicleCode = b.CustomerVehicleCode 
where LicenseNo = '{0}' AND VehicleType = '{1}' AND Color = '{2}' AND ChassisNo = '{3}'
order by TransactionDate desc