CODEWITHSUNDEEP
sqlwhere-clause
Roger Schneiter
Roger Schneiter

Reputation: 21

Sql multiple values in where clause from subquery

Basically, what I am trying to do is: I want a sql query that return all rows from a table where the id is (Some subquery which gives back 20 ids).

Like that:

SELECT * FROM People WHERE People.ID = (SELECT CreatedBy.PeopleID FROM CreatedBy)

Upvotes: 1

Views: 1498

Answers (3)

dbajtr
dbajtr

Reputation: 2044

use 'IN' rather than '='

SELECT * FROM People WHERE People.ID IN (SELECT CreatedBy.PeopleID FROM CreatedBy)

Upvotes: 1

Ravi
Ravi

Reputation: 1172

use in instead of =

SELECT * FROM People WHERE People.ID in (SELECT CreatedBy.PeopleID FROM CreatedBy)

Upvotes: 0

Gabri T
Gabri T

Reputation: 454

SELECT * FROM People WHERE People.ID in (SELECT CreatedBy.PeopleID FROM CreatedBy)

Upvotes: 1

Related Questions