I've got 4 tables I need to create a SQL statement from which are Cheque_History, Employees, Productions and Employers.

Cheque_History is joined to Employees via Employee_Id.
Employees is joined to Productions via Production_Id.
Productions is joined to Employers via Employer_Id.

I need all values from Cheque_History, FirstName and Surname form Employees, Title from Productions and Name from Employers.

My problem is that not all cheques in Cheque_History have an Employee_Id (as they may have been cancelled), therefore I need a Right Join between Cheque_History and Employees to get all of the cheques.

Can anybody help please.