selecting one unique entry

dreams4000

Hi there, I am trying to select a bunch of entries from a project team list. Some teams have the same person on them. I have the system selecting all the folks just fine, but if the person is on more than one team the system counts them as a unique person. Each person has an id and that id is the same no matter what team they are on. Is there some way I can have in the where statement that it pull only the unique ids?

right now my where statement is showing this, but I am not sure what to try to get the options i already have as well as pulling only unique ids. (ie. I have 14 people total, they are all on different teams except two which are on two teams.. then it shows that I have 16 people, even though it is actually only 14)

Thanks for any help!

WHERE mem.profil = '1' AND (tea.status = '3' OR tea.status = '2')

AstroTeg

A GROUP BY will probably work, but it could be helpful to see the rest of the query...

dreams4000

You rock Astro. That looks like it fixed it. The reason why I didnt put the select is that this particular program is using a default select for a number of items and so it has a bundle of variables in it and all I really can work with at the time is the where statement.. didnt think it would help the question much to have more confusing info =p Ill play around with this a bit more, but it is looking like it is working. Appreciate the help so much!