DISTINCT or GROUP BY don't seem to help

I want this query to list each app_name only once... Neither SELECT DISTINCT nor GROUP BY seems to work.

SELECT app_table.name AS app_name, app_table.id AS app_id, relationship_table.client_id AS client_id

FROM app_table LEFT OUTER JOIN relationship_table ON (app_table.id = relationship_table.app_id)

re: DISTINCT or GROUP BY don't seem to help

nevermind, I didn't understand what I needed. I found a way through the app to accomplish my goal.