Hi SQL Gurus,

I need to join two tables say Table I and Table W

Table I is like below

Numbers Values
1 A
1 B
2 C
3 D

Table W is Like Below
Numbers Boolean
1 Yes
1 Yes
2 Yes
3 Yes

I need to query to join Table I and W where Boolean value is Yes in Table W but there is no D in Table I in Oracle database. The answer would be
Number
1
2
Can someone help me get a query?