Thread: msQuery: is JOIN command possible in Excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sharon sharon is offline
external usenet poster
  
Posts: 48
Default msQuery: is JOIN command possible in Excel?
I am writting a SQL sentence in msQuery and it says "Impossible to add
(SELECT table", in the next sentence:

SELECT id_User,id_PC,vTime FROM (SELECT 1 AS PC_new.id_User
`c:\PC_office`\PC_new.DBF PC_new UNION ALL SELECT 2 AS PC_old.id_User
`c:\PC_office`\PC_old.DBF PC_old)
WHERE id_User Like 'TED%'

Is it possible to do in Excel? What's wrong in my sentence?
Any idea?


Reply With QuoteReply With Quote