2 tbls w/same field/datatype - 1 lookup tbl - 1 tbl joins 1 won't why?

[kenndot]

I have two tables

tblallclaims
tblpaidclaims

they both have this field: age decimal 9

I have a lookup table
tbl_ageranges
and an alias of this lookup table
alias_tbl_ageranges

this table&view have fields - exactage decimal 9

tblallclaims will link to tbl_ageranges on the exactage field

tblpaidclaims will not link to either the table or the view on the same field that tblallclaims will

can you tell me what I can check?

I've checked the datatypes a hundred times and yes they do match. I have removed and readded the tables and the joins. I have changed the datatypes back and forth and each time the same table just won't link to either the view or the table itself.

What am I missing here?

 

[kenndot]

Just in case anyone has a similar problem... I figured out the solution.

Somewhere in SQL Server an older view of the table that I am using in the database was stuck and that had a different datatype for the field I was working with. So eventually I decided to recreate the view in SQL Server and Voila!