I have two tables that i am performing left joins on. My problem is that most of the data in the two fields i am trying to match on are the same, but there are some instances when the data is not exactly alike but similar.
Table 1's field data:
Net 45 days from INV
Table 2's field data:
The problem is that "Net 45" and "Net 45 days from INV" mean the same thing.
The query i am trying to write looks like the following:
from Table1 c
left outer join Table2 pt ON Table1 = c.id = pt.id
left outer join Table3 ar ON pt.discount = ar.Disc AND
pt.percent = ar.percent AND
pt.days = ar.days AND
pt.desc = ar.desc ---My issue is here.
Can i use a like clause or contain clause here because the SOME of the data does not match exactly, but most of it does?
Any suggestions on how to write this query?