Extract rows with different string
Hello people, this is my first post... I hope your help
The Db is MySQL 5.0.45-community-nt via TCP/IP
If I execute this query:
FROM TableA A
INNER JOIN TableB B ON
A.CODE = REPLACE(B.CODE, "-","")
The result is 0 rows fetched, because the code of TableB is XX001380410:
in the code of TableB I have other zero: XX001380410
Can someone help me?
Thanks in advance.