Selection of rows with same values only

[Fishker]

I've got a problem figuring out a query which can do the following,
I'll make a simplified example and give an example result I'm
expecting.

Table1
ID X
1 NO
1 NO
2 YES
2 NO
2 NO

Result should be
ID X
1 NO

In words, I've got a table with Items with each their own ID, a table
with suppliers with their ID, a table with additional information that
depends on itemID & supplierID. Each item has multiple suppliers with
their relational 'additional information'. I need to find the items
where in the additional information table the value for a Yes/No field
is NO for each supplier for that item. So once 1 supplier has a YES
for that field I don't need the item in my results.

 

[Fishker]

...

I've figured it out, I just added a WHERE id NOT IN (SELECT id FROM
tbl WHERE X="Yes") - couldn't be easier, took me a while though!