joining three mySQL tables
I want to display the last successful login for each user on my admin page that lists all system users. I'm already displaying info from two tables as follows:
SELECT *,SUM(CPD.Minutes) as Hours
FROM para_users LEFT JOIN CPD on para_users.id = CPD.User_ID
This displays the number of CPD training hours that each user has logged next to their details on the results page.
I've created a LastLogin table and added an insert record behavior on the login page, which records the login timestamp and the user email. Now I want to display the last login time on the results page for each user, so I need to join the LastLogin table on the user's email address, something like this:
SELECT *,SUM(CPD.Minutes) as Hours
FROM para_users LEFT JOIN CPD on para_users.id = CPD.User_ID JOIN LastLogin ON LastLogin.UserEmail = para_users.user_email
However, this only displays the users that exist in the LastLogin table, but I need to display all users whether or not their details are recorded in the LastLogin table. Any help would be appreciated as I'm not great on table joins!