Is this a correctly made JOIN:

// Build SUBJECT navigation and gather SUBJECT data here--------------------------------
$sqlCommand = "SELECT id, linklabel, pos FROM subjects INNER JOIN pages on id = pages.subjectid ORDER BY pos ASC"; 
$query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error());



It is practically impossible to predict without knowing the actual structure of both the tables and their relations.

Hmm Sorry :-)

I think im on the wrong track anyways, and cant use joins in what I want to achieve.