Query that returns a result for every id in a list, otherwise return nothing

[this.user]

Given the following table:

 

id

name

Job

 

I am trying to find the best way to execute an All or nothing query.

 

Given a list of ids, for example:

 

x = {1,2,3,4,5}

 

Execute a query, where:

 

Job: Craftsman

 

AND

 

ID: y

 

where y is a value in x.

 

However, the query should fail, if it fails to find a match for every id.