Multiple Part Identifier Cannot Be Associated

Question

select (case when t.freeplayabandoned != f.freeplayabandoned then 'freeplayabandoned'
             when t.freeplaydownloaded != f.freeplaydownloaded then 'freeplaydownloaded'
    end) 
from testtable t where not exists (select * from freeplay.egmfreeplay f  where f.freeplaydownloaded  = t.freeplaydownloaded)

I tried to get testtable entry column names that do not match freeplay.egmfreeplay names

and I get an error on error

Msg 4104, Level 16, State 1, Line 1 Multiple identifier "f.freeplayabandoned" cannot be associated. Msg 4104, Level 16, State 1, Line 1 Multiple identifier "f.freeplaydownloaded" cannot be associated.

can anyone help?

Answer 1

f is inside a subquery inside an existing call. You cannot use it outside of a subquery.