I have two tables in MS Access that are suppose to share a common key...however the number in one is actually stored as a string while the other is stored as an int.
I think I want to use the convert() function...
Select blah1.key, blah2.key
ON blah1.key = blah2.key
How do I use the convert() or something like it for the join?