I've got two tables
user table - id
- username
- fname
- lname
- group_id
event Table
- id
- user_id
- event_time
- event_date
- event ('Arrival','Departure','Break',etc..) My problem is getting all user by group and joining other table even date, but it should be base on 'event_date' I use `LEFT JOIN` and `LEFT OUTER JOIN` but because I have to specify the `event_date` not all user can be shown because some are absent. I made this
SELECt * FROM
user as u
LEFT OUTER JOIN event as e
ON u.id = e.user_id
WHERE
u.group_id = 6
AND ( e.event_date = '2016-07-05' AND e.event = '