Hi
Vignesh,
Please use
UNION to combine both result like:
select Users.UserId,Users.EmpNo,EmpPayments.SalBasic from Users join EmpPayments on Users.UserId=EmpPayments.UserId where EmpPayments.MonthId=6 and EmpPayments.YearId=2010 and Users.MainContractorSw='Y' and Users.UserId=43
UNION
select Users.UserId,Users.EmpNo,EmpPayments.SalBasic from Users join EmpPayments on Users.UserId=EmpPayments.UserId where EmpPayments.MonthId=6 and EmpPayments.YearId=2010 and Users.MainContractorId=43
Please do let me know, if you have any doubt.
Please provide "
Vote":thumbsdown: if this would be helpful, and make "
Accept Answer" if this would be correct answer.:rose:
Thanks,
Imdadhusen