匹配来自两个不同表的字段的前3个字符 [英] Match first 3 characters of a field from two different tables

问题描述

我有两个不同的表，包括姓，姓和DOB。我做了一场直接的比赛，但想看到一个匹配，其中Surname和DOB完全匹配，但是匹配前3个字符的名字（有些拼写略有不同）


我怎么样？走吧？


谢谢，

Hi,

I have two different tables with forenames, surnames and DOB. I have done a straight forward match but wanted to see a match where Surname and DOB Matched exactly but match the forename from the first 3 characters (some are spelt slightly differently)

How would I go about this?

Thanks,

推荐答案

嗨


没有看到你查询它是有点难以提出明确的答案，但我想在某处你需要这样的东西

Hi

Without seeing you query it is a bit difficult to suggest a definitive answer, but I imagine somewhere you will need something like this

展开 | 选择 | Wrap | 行号

我会在类似的行上提出建议：

I would suggest something on similar lines :

展开 | 选择 | 换行 | 行号

展开 | 选择 | Wrap | 行号

这篇关于匹配来自两个不同表的字段的前3个字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！