I have 4 queries i want to simultaneously execute on one worksheet....I pasted all 4 queries into the Data Source screen under SQL statement. when it executes it only provides one set of results
example in SQL Statement window
Select top 10 *
from XXXXXX
where
Select top 10 *
from YYYYY
where
Select top 10 *
from ZZZZ
where
Select top 10 *
from WWWW
where
Bookmarks