In the following statement I would like to recieve only one row per post_topic value using the DISTINCT keyword, but I would also like to be able to retrieve the contents of a field named post_subject in each of these rows, but post_subject should not be included in the DISTINCT clause..

SELECT DISTINCT post_topic, post_subject FROM tblPost

How do I do this?