var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL statement help
I have a clients table.
I also have sign_ins table where clients attendance is being tracked.
The 2 tables are related by the Client's ID.
I want to be able to select all clients and do a left join to find out the last sign in date. If there are no sign ins, I want the null value to return hence the left join.
the problem is that I am having trouble retrieving just the latest one.
GROUP BY ID