I can't remember how to fix this. I want to join this one table using the TIN field, but I am getting this error. Is there an easy fix for this. I did this before, but I can't remember.
This is the error I am getting.
Msg 8114, Level 16, State 5, Line 2
Error converting data type varchar to float.
Inner join IMPact.dbo.pcsa on pcsa_tax1 = TIN
and pcsa_lname = [Provider First] and pcsa_fname = [Provider Last]
join impact.dbo.pcsp on pcsa_id1 = pcsp_id1 and pcsa_id2 = pcsp_id2
left join impact.dbo.pcs on pcsa_id1 = pcs_id1
pcsp_trm is null