I have two tables - and am joining on two fields with the same name:
I have cross-checked, and unfortunately, only a portion of the records across these two tables link and are in the output result. The other names look exactly the same - but are not in the output.
Unfortunately I cannot upload examples.
I did trim the fields and truncate the names prior to this join.
Can you please offer why this may be happening?