[AccessD] Urgent query help needed

Benson, William (GE Global Research, consultant) Benson at ge.com
Fri Jun 1 13:13:12 CDT 2012


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')
)



More information about the AccessD mailing list