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
TableB:Code:ID CODE 1 XX00138410
If I execute this query:Code:ID CODE 18 XX00-1-380410
The result is 0 rows fetched, because the code of TableB is XX001380410:Code:SELECT A.CODE, B.CODE FROM TableA A INNER JOIN TableB B ON A.CODE = REPLACE(B.CODE, "-","")
in the code of TableB I have other zero: XX001380410
Can someone help me?
Thanks in advance.