How would I go about querying my database and only returning data that is not redundant? For example I have a database of jobs with many of the same clients listed for multiple jobs.
Now I want to grab a list of all those clients form this job database. But I don't want to see my list show the same client info repeated over and over for as many times as they appear in the db for each job they were listed under.
i.e.
job_db
job_id |client
1 |mickey
2 |goofy
3 |donald
4 |goofy
5 |mickey
6 |mickey
7 |pluto
8 |donald
my query = SELECT client FROM job_db ORDER BY client ASC
would return
donald
donald
goofy
goofy
mickey
mickey
mickey
pluto
How do I have my query return:
donald
goofy
mickey
pluto
Thanks for advice
3dron
