“查询必须具有一个目标字段”打开表时出错？ [英] "Query must have one destination field" error when opening a Table?

问题描述

请帮我解开这个谜团。我做了Union查询把一些表放在一起......它运行了一次，向我展示了数据。试图第二次运行它，它找不到其中一个表。我想看一下其他表......它给了我一条消息查询必须至少有一个目标字段。我正在尝试打开一张桌子。双击它。

[IMG] C：\ Documents and Settings\lskalska\Desktop\table Mystery.jpg [/ IMG]


任何想法，有人吗？

解决方案

我有点担心你的意思汇总一些表格 ;。您可以在设计视图中打开Union查询，将视图更改为SQL并在此处发布SQL（使用代码标记）吗？这样可以更容易地看到可能发生的事情。


Jim

Jim，

这里''联合查询代码。但同样，我只是试着看一张桌子。联盟查询在那时关闭。

展开 | 选择 | Wrap | 行号

神圣的Snapdragons，蝙蝠侠！也许你最好备份一步并解释数据库应用程序的用途是什么，以及所有这些HR _ ****表以及它们中的字段是什么。


我想我们可能会有轻微的规范化问题，但如果你解释一下你想要实现的目标，我们就会从那里开始。


Jim

Please help me with this mystery. I did the Union query to put together some tables...it ran once, showing me the data. Tried to run it for the second time and it could not find one of the tables. I wanted to look at one of the other tables....and it gives me a message " Query must have at least one destination field". I am trying to open a Table. Double clicking on it.
[IMG]C:\Documents and Settings\lskalska\Desktop\table Mystery.jpg[/IMG]

Any idea, anyone?

解决方案

Hi,
I''m a bit worried about what you mean by "put together some tables". Can you open your Union query in design view, change the view to SQL and post the SQL here (using the code tags)? That will make it easier to see what may have happened.

Jim

Jim,
Here''s the Union query code. But again, I just tried looking at a table. Union query was closed at that moment.

Expand|Select|Wrap|Line Numbers

Holy Snapdragons, Batman! Perhaps you''d better back up a step and explain what the purpose of the database application is, and what are all these HR_**** tables and what are the fields in them.

I think we might have a slight normalisation problem, but if you explain what it is that your are trying to achieve, we''ll go from there.

Jim

这篇关于“查询必须具有一个目标字段”打开表时出错？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！