I have a table structure like below:-
1. tbl_Employee
Id int
ename nvarchar(50)
eaddress nvarchar(MAX)
2. tbl_Salary
id int
empid int
salary_amt nvarchar(20)
Error: Conversion failed when converting the nvarchar value '3,1' to data type int.
Note:- here in above error 3 and 1 is id of employee.
my query is :-
select * from salaryInfo where empid in ('3,1')
when above qurey execute then mentioned error will showing.
please solve the query so that record related to empid can be the output.