如何仅使用部分匹配链接两个表 [英] How Do I Link Two Tables with Only a Partial Match

问题描述

一个表显示123456 ID，另一个表显示123456/1

解决方案

Suzemt，


你在什么情况下工作？访问？或通过ODBC？

干杯，

Oralloy

您可以将LIKE谓词与通配符一起使用。

我正在使用Access。我想检索与上面显示的数字匹配的记录。该字段是主键。

one table shows 123456 in ID the other table shows 123456/1

I want to return records where these two fields match but I don''t want to specify the actual number, just where these fields match, even if it is partially. Help !

解决方案

Suzemt,

In what context are you working? Access? Or through ODBC?

Cheers,
Oralloy

You can use the LIKE predicate with wildcards.

I am using Access. I want to retrieve records that match the numbers as shown above. The field is the primary key.

这篇关于如何仅使用部分匹配链接两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！