sql - Select where column in not null array -

i trying :

select *  table  column in (select col table2 col2 = value ) 

but want check if second request doesn't return null array.

how possible?

thanks in advance

simply add not null check in subquery omit null values returned.

select * table column in  (select col table2 col2 = value , col not null);