salarypayment--paymentid,userid,month,year,salarypaid,chequeno,comment-contain record whose payment has done
tbl_users-userid,empname,emailid,address-conain record of all emp
i have 2 dropdown month,year
suppose user select jan 2012 from dropdown then
it show record in gridview of those
emp whose salary is pending and whose salary is already paid
i am not able to fire sql query anyone plz help me
i tried this
select u.UserID,u.FirstName+' '+u.LastName[name],st.SalaryPaid[SalaryPaid],dbo.ufn_MAFormatDate(st.PaymentDate)PaymentDate,st.ChequeNo[ChequeNo],st.Comments[Comments],pt.Desc_[PaymentType],st.PaymentID
from tbl_Users u
left outer join tbl_SalaryPaymentDetails st on st.UserID=u.UserID
left outer join TBL_PaymentType pt on pt.PaymentTypeID=st.PaymentType
where u.UserID in(select UserID from tbl_SalaryPaymentDetails where month =1 and year=113)