Type mismatch in query

[SSharp]

I have two tables that I need to query.
Table 1 has the field stored as a data type is a Number (Long Integer).
Table 2 has the field stored as a data type of Text.
They are essentially the same field in both tables, two different developers created the data types.


I don't have the option to change one of the data types at this time.
Is there an easy way that I can run a simple query over these two tables using the mismatched fields as the join?

[pbaldy]

You can force the issue in SQL view:

FROM OneTable INNER JOIN OtherTable ON OneTable.NumericField = CLng(OtherTable.TextField)

Or you can go the other way with CStr().