Joining across multiple columns

wonka1234

Hi all,

I am trying to wrap my head around this, I am trying to do a join like so:

Table a: 

a	b	c	d	e	f	g	h	i	j	k
John		John				Smith		John		John

Table b:

ID	Other
John	HRUS1
John	ADTDBFG
John	ACF2
Smith	HDV
Smith	VERNA
Smith	CMREV
Smith	PCPAA
Smith	S2P
Smith	G0042
Smith	G0043
Smith	CITRIXRA
Smith	TNE

Current result:

a	b	c	d	e	f	g	h	i	j	k	Other
John		John				Smith		John		John	adtdbfg
John		John				Smith		John		John	acf2
John		John				Smith		John		John	hrus1

Expected Result:

a	b	c	d	e	f	g	h	i	j	k	Other
John		John				Smith		John		John	hrus1
John		John				Smith		John		John	adtdbfg
John		John				Smith		John		John	acf2
John		John				Smith		John		John	hdv
John		John				Smith		John		John	verna
John		John				Smith		John		John	cmrev
John		John				Smith		John		John	pcpaa
John		John				Smith		John		John	s2p
John		John				Smith		John		John	g0042
John		John				Smith		John		John	g0043
John		John				Smith		John		John	citrixra
John		John				Smith		John		John	tne

Trying something like this:

where I join I to a,b,c,d,e . etc

What does get my expected results:

but here I'm using two filters, both on John and Smith, and I get the correct results.

In reality I cannot do this filter.. as I have many names and cant put that many filters.

Does anyone have a smarter way to join this and get the expected results? 

I cannot wrap my brain around this.

ArtApa

Hi @wonka1234 - Here is an idea:

JoiningAA.yxmd