Thread: problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] adrian.popescu@gmail.com is offline
external usenet poster
 
Posts: 3
Default 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