Simple query in Mysql that i can't seem to get right! Joining tables

[c_shelswell]

Hi i'm sure this has a very simple answer. I'm looking to query mysql joining two tables. basically i have:

Media
media_id - title - picture

and

Purchases
media_id - quantity

all im looking to do is query mysql for the title of the media_id i give to it from the purchases table. I'm getting some results but i provides me with the title as many times as the media_id appears in purchases i only need it once.

Here's my code.
[code]select media.title, media.picture from media left join purchases using (media_id) where purchases.media_id='4';[/code]

i'm pretty new to mysql and this is really just a guess if anyone could help that would be great.

Thanks very much

[c_shelswell]

Ooops managed to get it. I used this.

[code]select distinct media.title, media.picture from media left join purchases on purchases.media_id=media.media_id where purchases.media_id=4;[/code]


perhaps there's a better way?

[fenway]

That's fine, but I'm not sure why you have distinct.

[c_shelswell]

It seems if i don't have the "distinct" i get as many titles as there are purchases of that title in the purchases table. I'm only looking to get the name of it once.

[akitchin]

rather than DISTINCT, you could simply LIMIT your query to return one row (ie. LIMIT 1).