查询语法错误，子句不完整

liaozy

请各位高手帮忙审查下，总是提示“查询语法错误，子句不完整”，不知道为什么，谢谢

SELECT F1,F5,F6,F7,F8 FROM [庞慧卿$B5:AN3000] WHERE F19 IS NOT NULL OR F20 IS NOT NULL OR F26 IS NOT NULL UNION ALL SELECT F1,F5,F6,F7,F8 FROM [张小素$B5:AN3000] WHERE F19 IS NOT NULL OR F20 IS NOT NULL OR F26 IS NOT NULL UNION ALL SELECT F1,F5,F6,F7,F8 FROM [马丹丹$B5:AN3000] WHERE F19 IS NOT NULL OR F20 IS NOT NULL OR F26 IS NOT NULL UNION ALL SELECT F1,F5,F6,F7,F8 FROM [王雪芬$B5:AN3000] WHERE F19 IS NOT NULL OR F20 IS NOT NULL OR F26 IS NOT NULL UNION ALL SELECT F1,F5,F6,F7,F8 FROM [丁娜$B5:AN3000] WHERE F19 IS NOT NULL OR F20 IS NOT NULL OR F26 IS NOT NULL UNION ALL SELECT F1,F5,F6,F7,F8 FROM [张晓春$B5:AN3000] WHERE F19 IS NOT NULL OR F20 IS NOT NULL OR F26 IS NOT NULL UNION ALL SELECT F1,F5,F6,F7,F8 FROM [张娜$B5:AN3000] WHERE F19 IS NOT NULL OR F20 IS NOT NULL OR F26 IS NOT NULL UNION ALL SELECT F1,F5,F6,F7,F8 FROM [张国英$B5:AN3000] WHERE F19 IS NOT NULL OR F20 IS NOT NULL OR F26 IS NOT NULL UNION ALL SELECT F1,F5,F6,F7,F8 FROM [杨秀花$B5:AN3000] WHERE F19 IS NOT NULL OR F20 IS NOT NULL OR F26 IS NOT NULL UNION ALL SELECT F1,F5,F6,F7,F8 FROM [刘娜$B5:AN3000] WHERE F19 IS NOT NULL OR F20 IS NOT NULL OR F26 IS NOT NULL UNION ALL SELECT F1,F5,F6,F7,F8 FROM [李树果$B5:AN3000] WHERE F19 IS NOT NULL OR F20 IS NOT NULL OR F26 IS NOT NULL UNION ALL SELECT F1,F5,F6,F7,F8 FROM [李海兰$B5:AN3000] WHERE F19 IS NOT NULL OR F20 IS NOT NULL OR F26 IS NOT NULL UNION ALL SELECT F1,F5,F6,F7,F8 FROM [李东红$B5:AN3000] WHERE F19 IS NOT NULL OR F20 IS NOT NULL OR F26 IS NOT NULL UNION ALL

liaozy

明白了，多谢

chinahyong

谢谢我也学习了

tmhcan007

select "nj",* from 'C:\Users\user\Desktop\江苏事项\练习\nj'.'2$''2$' union all
select "nj",* from 'C:\Users\user\Desktop\江苏事项\练习\nj'.'nj$''nj$' union all
select "nj1",* from 'C:\Users\user\Desktop\江苏事项\练习\nj1'.'2$''2$' union all
select "nj1", * from 'C:\Users\user\Desktop\江苏事项\练习\nj1'.'nj$''nj$'

这个语句哪里错了。我想关联系两个表做透视？一直会出现查询语法错误