sql server new users: I have an sql to select 'customers', something like

Select * from clients
inner join cases on clients.id = cases.clientid

The client may have multiple cases and if I run the query like that I may
get the same client multiple times, how can I only display the client once
when there are multiple results.

The have an ID which is unique so that might help .. help is appreciated.

Aleks

Already answered on the thread from 17:38

--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
"Aleks" <arkark2004@hotmail.com> schrieb im Newsbeitrag
news:uwq$d5CeFHA.3492@TK2MSFTNGP14.phx.gbl...
[quoted text, click to view]