Hello all,
Again my beginner's SQL knowledge has let me down. Ill get straight to the point. I have 2 tables as follows:
status: //keeps track of users viewing/completing pages from the content table
statusid (primary key)
userid (foreign key from table users)
id (foreign key from table content)
status1 //keeps track of all users either starting the page or completing the page
date
content:
id (primary key)
phase_num
task_num
title
What i have been trying to do all day yesterday is:
retrieve all pages from the content table and for each page that the user has visited (stored in the status table) or completed, retrieve its status.
I tried the following query, but did not work:
SELECT DISTINCT content.phase_num, content.task_num, content.title, status.status1, status.date FROM content, status WHERE status.id=content.id
I hope that was clear, please let me know if you need additional information.
Any type of help will be appreciated........
Thank you in advance,
