problem adrian.popescu[ at ]gmail.com 24.07.2006 13:13:34 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