Category: SQL Server

27 Aug 2019 18:26

Joined:	13/03/2015
Level:	Silver
Points:	144

Points:	2

How to check two id's at a time in table

Example

select name,id from table
where (name,id) in (select name,id from table2)

Error: An expression of non-boolean type specified in a context where a condition is expected, near ','.

it's thourging error please update the answer.

#769956

29 Aug 2019 10:58

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	2

Hi

you can use multiple id here
select name,id from table where id in (100,121,140)

this is not suitable for you

share more info for this?

Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com

'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

#769967

23 Sep 2019 10:23

Joined:	06/04/2012
Level:	Gold
Points:	4230

Points:	2

Hi Sadiq,

The syntax is wrong:
select name,id from table
where (name,id) in (select name,id from table2)

correct syntax:
select name,id from table
where name in (select name from table2) and id in (select id from table2)

Hope this is what you are looking for.

Regards,
Nirav Lalan
DNS Gold Member
"If you can dream it, you can do it."

How to check two id's at a time in table

About dotnetspider.com

Quick Links

General

Services