in sql database how to map data of 2 table ..1 common field but in one table its data type is 111111A and in other 111111 only

Question

pl reply

Answer 1

SELECT table1.colume, table2.colume1
FROM table1
INNER JOIN table2
ON table1.commonid=SUBSTRING(table2.commonid, 1, CHAR_LENGTH(table2.commonid) - 1);

If it does not work please reply back.

Answer 2

ok thx..