I have two tables with different granularity.
table 1 - field a
table 2 - field b and field c
The field a value (string) in table 1 can appear in field b or field c in table 1.
I 'm trying to do a join using something like contains or search string in field a in any of the two fields b or c and retrieve them the information from table 2 for that record found.
So far, i didn't manage a way to do it in an easy way. I've seen you can inject certain join conditions and filter only certain wildcard patters but not the way to implement this logic yet.
Any help will be great.
Thanks in advance.
is it the full ID?
meaning field A needs to equal either B or C in Table 2?
Psudo code being:
So Table1.Field_A = (Table2.FieldB or Table2.FieldC)