访问连接不受支持 [英] Access Join Not Supported

问题描述

我有如下查询：

从table1中选择a.c1，b.c1 
作为左边将view1作为b加载到a.c2 = b.fixedc2; 

此查询失败。 但是，如果连接是INNER连接，它将起作用。

View1的设置如下。数据库没有规范化，所以我必须先修复密钥才能加入它。我无法规范化数据库（仅查看）。

选择a.c1，cdbl（[a] 。[c2]）作为fixedc2 
来自table2作为a; 

任何想法？我真的需要左连接来查找table1中哪些行在table2中没有子节点。

左外连接不起作用。

---

Mediocre Access 2016 | （宝贝）初学者C夏普|在Active Directory中确定（2012 R2）|分散对DNS / DHCP的理解|团体政策的可笑经验| MSDN论坛上的专家提问者

解决方案

你得到什么错误？

I have a query like follows:

select a.c1, b.c1
from table1 as a left join view1 as b on a.c2 = b.fixedc2;

This query fails.  It will work if the join is an INNER join however.

View1 is setup as follows. the database isn't normalized, so i have to fix the key before I can join on it. I can't normalize the database (view only).

select a.c1, cdbl([a].[c2]) as fixedc2
from table2 as a;

Any ideas? I really need the left join to find which rows in table1 do not have children in table2.

Left outer join does not work.

---

Mediocre Access 2016 | (Baby) Beginner C Sharp | OK at Active Directory (2012 R2) | Fragmented understanding of DNS/DHCP | Laughable experience with Group Policy | Expert question asker on MSDN Forums

解决方案

What error do you get?

这篇关于访问连接不受支持的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！