I use this query:
SELECT title, author, scripts.id, ROUND(AVG(marks), 2) AS 'mid' FROM rating INNER JOIN scripts ON scripts.id = rating.scriptid GROUP BY scriptid ORDER BY title
The only problem is, when there isn't any row in the table rating whith the number 1 in the field scriptid.
But there is a row in the table scripts with the id 1, I don't get any information of that row. I only get the informaton about the scripts(rows) who are already rated.
But though I want that information. How can I do that?
tnx alot
