ms-access:数据库引擎找不到输入表或查询 [英] ms-access: DB engine cannot find input table or query

问题描述

这是查询:

SELECT *
FROM (SELECT [Occurrence Number], [Occurrence Date], [1 0 Preanalytical (Before Testing)], [Cup Type], NULL as [2 0 Analytical (Testing Phase)], [2 0 Area], NULL as [3 0 Postanalytical ( After Testing)],NULL as  [4 0 Other], [Practice Code], [Specimen ID #] FROM [Lab Occurrence Form] 
WHERE NOT ([1 0 Preanalytical (Before Testing)] IS NULL)
  UNION
  SELECT [Occurrence Number],  [Occurrence Date],NULL, [Cup Type],[2 0 Analytical (Testing Phase)],  [2 0 Area], NULL,NULL, [Practice Code], [Specimen ID #] FROM  [Lab Occurrence Form]  WHERE NOT ([2 0 Analytical (Testing Phase)] IS NULL)
  UNION
  SELECT  [Occurrence Number],  [Occurrence Date],NULL, [Cup Type],NULL,  [2 0 Area], [3 0 Postanalytical ( After Testing)],NULL, [Practice Code], [Specimen ID #] FROM  [Lab Occurrence Form]  WHERE NOT ([3 0 Postanalytical ( After Testing)] IS NULL)
 UNION
  SELECT  [Occurrence Number],  [Occurrence Date],NULL, [Cup Type],NULL, [2 0 Area], NULL,  [4 0 Other] FROM  [Lab Occurrence Form], [Practice Code], [Specimen ID #]  WHERE NOT ([4 0 Other] IS NULL)
)  AS mySubQuery
ORDER BY mySubQuery.[Occurrence Number];

由于某种原因，它不喜欢[Practice Code].这绝对是表中的一列，所以我不明白这个问题.

for some reason it doesnt like [Practice Code]. it's definitely a column in the table so i dont understand the problem.

错误是

Microsoft Office Access数据库引擎找不到输入表或查询实践代码" ........

the microsoft office access database engine cannot find the input table or query 'Practice Code'........

推荐答案

好吧，错误说明了一切.它不是一张桌子.在您的问题中，您声明它是表中的一列. 您在<发件人之后紧跟[Lab Occurrence Form], [Practice Code], [Specimen ID #]，因此它假定所有列出的表中都有表.

Well, the error says it all. It is not a table. In your question, you state that it is a column in a table. You have [Lab Occurrence Form], [Practice Code], [Specimen ID #] right after a from, so it assumes all those listed there are tables.

这篇关于ms-access:数据库引擎找不到输入表或查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！