Needs advice on JOIN condition

My problem is that every join condition I use I get an error.

Any advice?

My problem is that every join condition I use I get an error. Your question looks more like a homework, and we have some limitation to give a solution. Could you post your current query, so that we may be able to give you some hints.