I have two database tables, Criteria and Students.

Criteria table contains columns CriteriaID, Description, Marks and Available.

Students table contains columns StudentID, Name, Criteria1 Mark Achieved, Criteria2 Mark Achieved, Criteria3 Mark Achieved.

This is my current SQL statement:

$query = ("SELECT * FROM criteria, students WHERE studentID=$id"); 

I am trying to create a table where I can display the marks available (from the Criteria table) with the marks achieved (from the Students table).

Do I need to contain some sort of join e.g. criteria id 1 (criteria table) be linked with criteria1 mark achieved (students table) bearing in mind there are many students?