When I try to do a INNER JOIN in ACCESS 97, It won't let me user Primary Keys and compare them with foreign keys, and I get a datatype mismatch errror. Anyone know why?
Printable View
When I try to do a INNER JOIN in ACCESS 97, It won't let me user Primary Keys and compare them with foreign keys, and I get a datatype mismatch errror. Anyone know why?
What are the two datatypes of the columns in those two tables?
The query just wasn't right. I had a nested INNER JOIN of about 3-4 levels, so it was getting a little confusing. Got what I wanted though...