I need to run a SQL query against my Exchaneg2k server using webdav.
The query needs to extract the same columns from 5 separate folders.
If I run the query against one folder - no problems, so I know my syntax is
However, then I try to modify the query to do a Union with the next folder
and the query fails.
strQuery = "select ""DAV:displayname"" FROM
""http://mail/exchange/SSITLab1/calendar"" UNION (Select ""DAV:displayname""
FROM ""http://mail/exchange/SSITLab2/calendar"" )"
(returns error status 400 if I include the UNION statement)
Are UNION queries supported in Webdav SQL?
where is the reference as to what is included/excluded in SQL webdav
I keep seeing it metioned in articles/books but I cant ever find it!
Al Blake, Australia