I have 2 tables: A and B.
Both tables have a field named ITEM.
The ITEM format in table A is like: ABCD-ABC12345678
The ITEM format in table B is : ABCDABC12345678 (with no "-")
How can in join this 2 tables based on the ITEM field?
I have tried this way:
SELECT A.ITEM, B.VENDNUM
FROM A LEFT JOIN B ON (REPLACE(A.ITEM,'-','')) = B.ITEM
It works but it does not link the table B.