[AccessD] Urgent query help needed

Urgently need some help reforming this query. The error message I am getting is that this operation is not allowed in subqueries.



select * 
from CMF 
WHERE  DUNS_NUMBER in 
                ('CAT280669','CAT267663','969801062','832747997','832747997',
          '832747997','832747997','824603229','808109941','600010862','338329211',
          '338329211','325550361','325550361','089506492','081735875',
          '059006937','059006937','059006937','024745853','006901995')

union 

Select * 
from CMF 
Where DUNS_NUMBER in
        (SELECT CHILD_CUSTOMER_DUNS 
                  FROM  customer_hierarchy 
                  where parent_customer_duns in 
                ('CAT280669','CAT267663','969801062','832747997','832747997',
          '832747997','832747997','824603229','808109941','600010862','338329211',
          '338329211','325550361','325550361','089506492','081735875',
          '059006937','059006937','059006937','024745853','006901995')
         UNION 
                 SELECT parent_customer_duns 
         FROM  customer_hierarchy 
                 where CHILD_CUSTOMER_DUNS in 
                ('CAT280669','CAT267663','969801062','832747997','832747997',
          '832747997','832747997','824603229','808109941','600010862','338329211',
          '338329211','325550361','325550361','089506492','081735875',
          '059006937','059006937','059006937','024745853','006901995')
)