Syntax Error (missing operator) in query expression

[sonoteacher]

Hello,

First, I am no expert (otherwise I wouldn't be here right?), but I am attempting to create a pivot table using several worksheets in a book and after inputting:

SELECT * QA-Total

union all


SELECT * QA-IT


union all


SELECT * QA-Protocol


union all


SELECT * QA-Technical

into the SQL, the Microsoft Query says that I have a Syntax Error (missing operator) in query expression '* QA-Total'.

I am not sure what this means or how to correct it.

Please advise.

 

[steve the fish]

Im no expert either but think you need a FROM in there SELECT * FROM QA-Total.

 

[sonoteacher]

Im no expert either but think you need a FROM in there SELECT * FROM QA-Total.

Thanks, but that did not correct the problem.