I am developing a LMS.I have three tables
1.sublesson_table
course_id,sublesson_id,sublesson_title 1 1. Title 1 2 2. Title 2 3 3. Title 3 4 4. Title 4
2.user Table user_id,user_name 1 Test 2 Test1 3 Test2
3.sublesson_complete_table completed_id,sublesson_id,user_id,status 1 1 1 completed 2 2 2 completed
Expected output
sublesson_id ,sublesson_title, user_id, user_name, status 1 Title 1 1 Test Completed 2 Title 2 1 Test Not Completed 3 Title 3 1 Test Not Completed 4 Title 4 1 Test Not Completed 1 Title 1 2 Test1 Not completed 2 Title 2 2 Test1 completed 3 Title 3 2 Test1 Not Completed 4 Title 4 2 Test1 Not Completed 1 Title 1 3 Test2 Not completed 2 Title 2 3 Test2 Not completed 3 Title 3 3 Test2 Not Completed 4 Title 4 3 Test2 Not Completed
I need to track each sublesson progress by each user using mysql.