I have two tables, one with the main users details in and a users movement table which has an entry to everything they do.
I want to pull out a list of all users which havent done a specific task, put only pull the results once.
So for example I have 3 users. One user has done 10 tasks. Another 5. The other 3.
The one that has done 3 tasks, one of which adds the action "Completed".
I want to get a list of all users which have NOT got an entry in the movements table with "completed" in the "action" column.
Also, I only want each user once. Instead of the users details for each movement entry.
I hope this makes sense.
P.S. I am using PHP and MySQL.
Thanks in advance for any help!