Hello Friends
with the help of inner join,i joined two table like that
select SR.amountpaid,SR.date,S.name from SupplierRecord as SR inner join Supplier as S on SR.Supplierid=S.Supplierid where Purchaseid ='0'
in this joining i get a date with time like below
amountpaid date name
1000 2013-01-21 12:30:18.000 Vishal
2000 2013-01-22 10:29:41.000 A Mandlekar
but i want a only date (ie.2013-01-21 ) will be come not datewithtime (2013-01-21 12:30:18.000).
so can you please help me.
thnx in advance.