type mismatch

[dethfire]

I get an access error of type mismatch, however every field is text, here is my sql

SELECT clients.* FROM clients LEFT OUTER JOIN description ON clients.userid = description.userid WHERE description.religion='cath'

any suggestions?

[r937]

cannot answer your mismatch error problem without more info, but from the query itself, it seems like an outer join is not necessary

are you sure the fields are all text? which client rows exactly are you trying to find?

[dethfire]

cannot answer your mismatch error problem without more info, but from the query itself, it seems like an outer join is not necessary

are you sure the fields are all text? which client rows exactly are you trying to find?

What other info do you need?

How would you write the sql statement better?

[r937]

more info for the mismatch error? table layouts (datatypes of each field, especially the religion one)

the outer join is used to find all clients, whether or not they have matching religion rows, but then you stipulate religion='cath', so an inner join makes more sense

rudy

[MarcusJT]

Are both userid fields of the same data type?
And is religion a string?