需要使用“OR”编辑查询数据表中的数据。加入 [英] Need to edit data in query datasheet with "OR" join

问题描述

我有一个使用OR的选择查询。加入。有了这个连接，我无法编辑查询数据表中的数据;如果我删除OR并且只使用一个连接，然后我可以编辑数据。我阅读了这篇文章，解释说我可以由于SQL特定语句而无法编辑。有没有办法解决这个问题，以便我不必打开这个查询，查找我想要更改的内容，然后返回并打开表格进行编辑？谢谢。

I have a select query that uses an "OR" join. With that join in place, I cannot edit the data in the query datasheet; if I delete the "OR" and only use one join, then I can edit the data. I read this article that explains I can''t edit because of the SQL specific statement. Is there a way around this so that I don''t have to open this query, look for what I want to change, then go back and open the table to edit? Thanks.

推荐答案

请发布sql语句和任何相关的表结构。


问候，

Scott

Please post the sql statement and any relevant table structures.

Regards,
Scott

展开 | 选择 | 换行 | 行号

为什么有两个Tailnumber和NTailNumberN字段？


Tailnumber是构成这两个表之间关系基础的外键吗？如果是这样，NTailNumberN字段在做什么？


我认为Harrison.Aircraft是指Harrison桌子的主键吗？


正如您所发现的，当连接的一侧为空时，使用左连接可能会出现问题。你能不能更好地了解你想要用这个来完成什么？


问候，

Scott

Why two Tailnumber and NTailNumberN fields?

Is Tailnumber the foreign key that forms the basis for the relationship between these two tables? If so, what is the NTailNumberN field doing?

I assume that Harrison.Aircraft refers to the primary key of the Harrison table?

Using a left join can be problematic when one side of the join is null, as you are finding out. Can you give me a better idea of the larger picture of what you are trying to accomplish with this?

Regards,
Scott

这篇关于需要使用“OR”编辑查询数据表中的数据。加入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！