select SR.amountpaid,SR.date,S.name from SupplierRecord as SR inner join Supplier as S on SR.Supplierid=S.Supplierid where Purchaseid ='0'
select SR.amountpaid, convert(varchar, SR.date, 23), S.name from SupplierRecord as SR inner join Supplier as S on SR.Supplierid=S.Supplierid where Purchaseid ='0'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)