issue with query (mysql 5.0)

[ixxalnxxi]

the following query works except when the UserComments contains no rows with the StationID. any idea how to return just the Station info in that case?

SELECT s.*, AVG(uc.Rating) AS Rating
FROM Stations s, UserComments uc
WHERE s.StationID = 4
AND s.StationID = uc.StationID
GROUP BY uc.StationID

[legendx]

Left Join:


SELECT s.*, AVG(uc.Rating) AS Rating
FROM Stations s LEFT JOIN UserComments uc ON s.StationID = uc.StationID
WHERE s.StationID = 4
GROUP BY uc.StationID


Also, you will probably have to GROUP BY all the fields in s.* for this to work properly.

[ixxalnxxi]

omg legendx U R SO SMART LOL.

that helped a bunch, i'm completely unfamiliar with any JOIN, have to read up on that ~ thanks again.