Filtering Again

I want to filter out a specific field (genre) from my product table within my database, someone suggested using:

SELECT DISTINCT genre FROM tbl

This is fine, but I want to get multiple values from my table e.g
product_id, type, title, genre, picture etc

How could I go about getting multiple values out, and filtering the genre field?

Cheers

Mike

why not try a sub query?

SELECT *
FROM tbl
WHERE genre IN
(SELECT DISTINCT genre
FROM tbl)

SC:

Ok not sure how to do this, keep getting errors with the code I have
tried to use.

Where am I going wrong?

"SELECT COUNT(genre) FROM PRODUCT WHERE type = \"cd\" (SELECT DISTINCT genre FROM PRODUCT)"

You seem to be doing something different now ?? What do you need to return?
SC:

Sorry to confuse things, at the moment it counts through genre but there are multiple entries for fields

I still need to return genre, but want it to filter genre so there are only 1 of each genre.

Does this make sense?