INNER JOIN tables with Access 2000 1

[numbered]

I can't get my query to work

SELECT
t1.first_name, t2.description
FROM
table_1 as t1
INNER JOIN
table_2 as t2
ON
t1.type = t2.id

Any ideas why it's not working...does INNER JOIN work with access?

 

[swampBoogie]

Yes,jet sql supports inner join. What's the problem? Error message? Incorrect result?

 

[numbered]

"Type mismatch in expression" is my error.

 

[Databaseguy]

The fields that you are trying to join on have to have the same data type. You can't join a text field on an integer, for example... Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[numbered]

I didn't know that.

Thank you very much!! That was exactly what my problem was.