- Joined
- Jul 20, 2006
- Messages
- 2
- Reaction score
- 0
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
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