or you can use a non standard join
SELECT *
FROM tbl1 INNER JOIN tbl2 ON tbl1.numfield=val(tbl2.textfield)
If your table with the text field has a lot of records, It would be better to convert the text field to a number so that indexing can be applied or add it as a separate field.