Mysql Select statement question

[Miko]

hi!

 

I have here a select statement with a left join:

 

SELECT m.sender_name1, m.sender_id, p.vis
FROM `Levensloop`.`peter` p LEFT JOIN `Levensloop`.`MPSAVIS` m
ON m.sender_id = p.vis

 

The field m.sender_id contains information like 2300000217, the 217 is a customer number, the field vis contains all the customer numbers but here the customer number is only 217 and not 2300000217.

 

I know that I can achieve the select statement with left join but I don't think I'm doing it right here.

 

Anyone can help me out here? Thanks!

[fenway]

You can extract that portion from your field -- of course, that won't use an index.