具有内部联接的选择查询是否可更新？ [英] Are select queries with inner joins updatable?

问题描述

Access 2000

尝试即使是最基本的查询 - 选择加入的连接（内部

加入）两个表 - 结果不可更新，我可以''告诉

为什么他们不是。所有权限都打开，记录集是动态集，唯一的

值是否等等..


如果它有帮助，这里是SQL。 。：


SELECT tbl.ID

FROM tbl INNER JOIN Master ON tbl.IDNumber = Master.IDNumber;


这些结果是否应该是可更新的？想法？谢谢！

Martin Lacoste

Access 2000
Trying even the most basic queries - select queries joining (inner
join) two tables - and the results are not updatable, and I can''t tell
why they aren''t. All permissions are on, recordset is dynaset, unique
values is no, etc.. etc..

Here''s the SQL if it helps..:

SELECT tbl.ID
FROM tbl INNER JOIN Master ON tbl.IDNumber = Master.IDNumber;

Should these results not be updatable? Ideas? Thanks!
Martin Lacoste

推荐答案

2004年7月2日14:41:30 -0700， ma ******* @ rogers.com （Martin Lacoste）

写道：

On 2 Jul 2004 14:41:30 -0700, ma*******@rogers.com (Martin Lacoste)
wrote:

Access 2000
尝试即使是最基本的查询 - 选择加入（内部
联接）两个表的查询 - 结果不可更新，我不能告诉<他们为什么不是。所有权限都打开，记录集是动态集，唯一的值是否等等等等。

这里的SQL是否有帮助..：

SELECT tbl.ID
FROM tbl INNER JOIN Master ON tbl.IDNumber = Master.IDNumber;

这些结果是否应该是可更新的？想法？谢谢！
Martin Lacoste

Access 2000
Trying even the most basic queries - select queries joining (inner
join) two tables - and the results are not updatable, and I can''t tell
why they aren''t. All permissions are on, recordset is dynaset, unique
values is no, etc.. etc..

Here''s the SQL if it helps..:

SELECT tbl.ID
FROM tbl INNER JOIN Master ON tbl.IDNumber = Master.IDNumber;

Should these results not be updatable? Ideas? Thanks!
Martin Lacoste

尝试将两个表的连接键放在查询中。


SELECT tbl .IDNumber，Master.IDNumber

FROM tbl INNER JOIN Master ON tbl.IDNumber = Master.IDNumber;

- Jim

Try putting the join key of both tables in the query.

SELECT tbl.IDNumber, Master.IDNumber
FROM tbl INNER JOIN Master ON tbl.IDNumber = Master.IDNumber;
- Jim

两件事：1）确保表有主键，2）确保你有
有最新的JET更新。

Two things: 1) Make sure the tables have primary keys, and 2) make sure you
have the latest JET update.

2004年7月3日00:50:36 GMT， dc****@aol.comS PNOAM（DCM Fan）写道：

On 03 Jul 2004 00:50:36 GMT, dc****@aol.comSPNOAM (DCM Fan) wrote:

两件事：1）确保表有主键，2）确保你有最新的JET更新。

Two things: 1) Make sure the tables have primary keys, and 2) make sure you
have the latest JET update.

好​​吧，呃！

是什么让你想出这些意见/建议？

Well, duh!
What made you come up with those observations/suggestions?

这篇关于具有内部联接的选择查询是否可更新？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！