excel problem
 

Hi

I have a problem in excel when i try to import data from MSSql with Import
external data: I must use the same condition in two places in the same
query..something like that:

select col2 from d where col1=? union select col3 from d where id not in
(select col2 from d where col1=?)

this query works perfectly in MSSql, but when I try to do this in my ".dqy"
file the excel tell me I have an error in my sql...

pls help me