I am trying to do a join between different tables using acct_id. Table 1 is the main linking table and has this field formatted as varchar(10). All other tables has it as has it as Decimal(10).
Table 1 also has blanks (not nulls) for acct_id. When I tried to use CAST I just get errors. I think it's coming from those blank fields but don't know how to fix it.
I'm using SQL going through a linked server.
Select * from openquery(CMFR1,'
from MSP_CR mcr
left join on dly_prod prod on mcr.acct_id = prod.acct_id
Then left joins on 4 other tables using the same mcr.acct_id =