Join with multiple condition with equal and Contain Condition

[NidhiAg]

Hi Team,

I am stuck with a simple join. I want to use multiple join condition with different expression

Table 1

Col A	Col B	Col C
1111	A	Nick
2222	B	Nancy
3333	A; B	John
4444	B	Happy

Table 2

Col X	Col Y
1111	A
2222	B
3333	A
4444	A

Condition 

Col A = Col X AND Col B contains Col Y

Output:

Col A	Col B	Col C
1111	A	Nick
2222	B	Nancy
3333	A; B	John

[Qiu · Accepted solution]

@NidhiAg 

We can do a join for the Col A = Col X part then set a flag for the condition Col B contains Col Y.