I have built a website and now my client wants to copy the data from another table [that i was i unaware of] into one of mine. This would be ok except the other table has one field that is text where mine is a number. The actual data contained is exactly the same and the person before me really should have used a number field but it's too late for that.
I have modified my table but now i cannot inner join fields of different data types.
SELECT [table1].*,[table2].* FROM [table1] INNER JOIN [table2] ON [table1].feild = [table2].field
How can i copy the data from one table if the datatypes are different but the data is identical?