goed selecteren (join?)

mysql_query("
SELECT m.id,m.titel,b.score 
FROM movies AS m 
INNER JOIN beoordeling AS b
ON (m.id=b.movie_id)
")
or die(mysql_error());

mysql_query("
SELECT m.id,m.titel,b.score 
FROM movies AS m 
INNER JOIN beoordeling AS b
ON (m.id=b.movie_id)
")
OR die(mysql_error());

SELECT * 
FROM movies 
INNER JOIN beoordeling on (movies.id=beoordeling.movie_id);

SELECT * 
FROM movies 
INNER JOIN beoordeling ON (movies.id=beoordeling.movie_id);

<?php
session_start();

require_once('database.php');

$query = mysql_query('SELECT * FROM
					 site_movies
					 INNER JOIN
					 site_beoordeling
					 ON
					 (site_movies.id=site_beoordeling.movie_id) ORDER BY site_movies.id ASC LIMIT 0,1') or die(mysql_error());
$i = 0;
while($rows = mysql_fetch_assoc($query)){
$titel[$i] = $rows['titel'];
$id[$i] = $rows['id'];
$scr[$i] = $rows['score'];
$i++;
}
?>

<?php
session_start();
 
require_once('database.php');
 
$query = mysql_query('SELECT * FROM
					 site_movies
					 INNER JOIN
					 site_beoordeling
					 ON
					 (site_movies.id=site_beoordeling.movie_id) ORDER BY site_movies.id ASC LIMIT 0,1') or die(mysql_error());
$i = 0;
while($rows = mysql_fetch_assoc($query)){
$titel[$i] = $rows['titel'];
$id[$i] = $rows['id'];
$scr[$i] = $rows['score'];
$i++;
}
?>

select m.titel, b.score from movies m, beoordeling b where m.id = b.movie_id

SELECT m.titel, b.score FROM movies m, beoordeling b WHERE m.id = b.movie_id

select m.titel, count(b.score) as aantal, sum(b.score) as totaal from movies m, beoordeling b where m.id = b.movie_id

SELECT m.titel, count(b.score) AS aantal, sum(b.score) AS totaal FROM movies m, beoordeling b WHERE m.id = b.movie_id

<?php
while($row = mysql_fetch_array($query)) {
$score = $totaal / $aantal;
echo 'Film '. $row['titel'] .' heeft een gemiddelde score van '. $score .' ('. $row['aantal'] .' beoordelingen)';
}

<?php
while($row = mysql_fetch_array($query)) {
$score = $totaal / $aantal;
echo 'Film '. $row['titel'] .' heeft een gemiddelde score van '. $score .' ('. $row['aantal'] .' beoordelingen)';
}

SELECT
	movies.*,
	SUM(score) / COUNT(beoordeling.movie_id) AS score
FROM beoordeling
INNER JOIN movies
ON (movies.id = beoordeling.movie_id)
GROUP BY beoordeling.movie_id;

SELECT
	movies.*,
	SUM(score) / COUNT(beoordeling.movie_id) AS score
FROM beoordeling
INNER JOIN movies
ON (movies.id = beoordeling.movie_id)
GROUP BY beoordeling.movie_id;