0

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

pl reply

22nd Nov 2016, 4:10 PM
Chander Mani
Chander Mani - avatar
2 odpowiedzi
+ 4
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.
22nd Nov 2016, 5:04 PM
Aditya kumar pandey
Aditya kumar pandey - avatar
0
ok thx..
23rd Nov 2016, 1:13 AM
Chander Mani
Chander Mani - avatar