From what I have read on the error your getting, it is because you are mixing the two types of join.

*= and =* are only included for backwards compatability with sql2000 and db compat level 80

You should be using the full join clauses like INNER JOIN, LEFT OUTER JOIN etc instead.