JOIN question.. im stuck

[abda53]

heres my database
table magazine
- id
-title

table magazine_sub
-user_id
-magazine_id
-date

magazine.id is the same as magazine_sub.magazine_id

im trying to join the two tables to do a query on it so i can show by each users id which magazines they can subscribe to, by showing which magazines they dont already have..

kinda stuck on this one..

[zzz]

Try

LEFT JOIN table magazine_sub ON ( table magazine_sub.magazine_id = magazine.id )