JOIN with some NULLs (newbie)

[Sven Delleq]

Posted here as suggested in sticky note on newbie branch.

I'm trying to get media files whether they have a corresponding description or not.

SELECT * FROM media_table JOIN media_description_table ON (media_table.description = media_description_table.id) WHERE _media_table.id IN (1,2,3,4,5);

This will ONLY pull media files IF the description exists (obviously).

How do I rewrite the above query to pull the media files even if there is no description id corresponding to the mediafile?