Hi,

i need some help with a query. Ive got 3 tables, one for the magazin(uid, name, price), subscriber (uid, firstname, lastname) and subscription(personID, magazineuid).

What i want to do is perform a query that lets me show all the names of the magazine in one column and whether or not a specific person is subscribed to that magazine. so it would somethin like this:

mags subscriptions for joe bloggs:

mag name---- subscribed
mag 1 ----------yes
mag 2 ----------yes
mag 3 ----------no
..etc

any ideas?