lets say i run it like this now im getting this wonder if im missing something , thanks with the join

Msg 207, Level 16, State 1, Line 5

Invalid column name...