try this..very generic

select * from i where values  <> 'D' and numbers in (select numbers from w where boolean = 'Y')

- Jaxnepali