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:

[wonka1234]

Thank you @ArtApa 

However I forgot to mention I have other columns! I surely dont want to do the key on those right?

Is there anyway I can narrow your key to certain columns only?

[ArtApa]

Hi @wonka1234 - Can you please be more specific and describe the rules?

[wonka1234]

Hi @ArtApa  ,

It seems like everything is joining, even the blanks.

Anyways around this? I am getting many joins.