|
|
You're in the
sql server new users
group:simple query select
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
No,
I only need the clients, but I need to filter out by a column that is in the cases column, but I don't want them repeated if there are multiple cases. A "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.de> wrote in message news:eyoeURDeFHA.612@TK2MSFTNGP12.phx.gbl... [quoted text, click to view] > Of you got two sources (cases and customers) you haveto qualify the > results. * will show all columns of the query and the two table, so > placing the Cases. > if you want only the cases solves the problem (or name the indivual > columns like Select Cases.caseID,Cases.SOmeothercolumn...) > > -- > HTH, Jens Suessmeyer. > > --- > http://www.sqlserver2005.de > --- > "Aleks" <arkark2004@hotmail.com> schrieb im Newsbeitrag > news:eYl4h4CeFHA.2420@TK2MSFTNGP12.phx.gbl... >>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 >> > >
This is the actual sql
This is actually the sql. SELECT c.Id , c.CaseId , c.EmpId, c.AlienId, c.FirmAddressId, d.UserId, d.FirstNm , d.MiddleNm, d.LastNm , c.FirmId, c.MainCase , b.MaidenNm,e.Processcatalog, c.archived, d.NiStatus, d.ExpiresOn FROM Cases c INNER JOIN Users as d ON c.AlienID = d.userid inner join users as b ON c.empid = b.userid INNER JOIN Processcatalog as e ON c.Process = e.ProcesscatalogID WHERE c.EmpID=MMColParam and d.FirstNm LIKE 'MMColParam3%' and d.LastNm LIKE 'MMColParam4%' AND c.archived =0 and d.Usertype = 'Contact' What I need is to select only those where d.userid are different from one another. How can I do this ? Aleks [quoted text, click to view] "Aleks" <arkark2004@hotmail.com> wrote in message news:u22mcVGeFHA.2700@tk2msftngp13.phx.gbl... > No, > > I only need the clients, but I need to filter out by a column that is in > the cases column, but I don't want them repeated if there are multiple > cases. > > A > > "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.de> wrote > in message news:eyoeURDeFHA.612@TK2MSFTNGP12.phx.gbl... >> Of you got two sources (cases and customers) you haveto qualify the >> results. * will show all columns of the query and the two table, so >> placing the Cases. >> if you want only the cases solves the problem (or name the indivual >> columns like Select Cases.caseID,Cases.SOmeothercolumn...) >> >> -- >> HTH, Jens Suessmeyer. >> >> --- >> http://www.sqlserver2005.de >> --- >> "Aleks" <arkark2004@hotmail.com> schrieb im Newsbeitrag >> news:eYl4h4CeFHA.2420@TK2MSFTNGP12.phx.gbl... >>>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 >>> >> >> > >
Of you got two sources (cases and customers) you haveto qualify the results.
* will show all columns of the query and the two table, so placing the Cases. if you want only the cases solves the problem (or name the indivual columns like Select Cases.caseID,Cases.SOmeothercolumn...) -- HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- "Aleks" <arkark2004@hotmail.com> schrieb im Newsbeitrag news:eYl4h4CeFHA.2420@TK2MSFTNGP12.phx.gbl... [quoted text, click to view] >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 >
Select * from Customers AS CO
Where Exists ( Select * from Cases CA where CA.CustomerID = CO.CUstomerID ) THat should work. HTH, Jens Suessmeyer. "Aleks" <arkark2004@hotmail.com> schrieb im Newsbeitrag news:u22mcVGeFHA.2700@tk2msftngp13.phx.gbl... [quoted text, click to view] > No, > > I only need the clients, but I need to filter out by a column that is in > the cases column, but I don't want them repeated if there are multiple > cases. > > A > > "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.de> wrote > in message news:eyoeURDeFHA.612@TK2MSFTNGP12.phx.gbl... >> Of you got two sources (cases and customers) you haveto qualify the >> results. * will show all columns of the query and the two table, so >> placing the Cases. >> if you want only the cases solves the problem (or name the indivual >> columns like Select Cases.caseID,Cases.SOmeothercolumn...) >> >> -- >> HTH, Jens Suessmeyer. >> >> --- >> http://www.sqlserver2005.de >> --- >> "Aleks" <arkark2004@hotmail.com> schrieb im Newsbeitrag >> news:eYl4h4CeFHA.2420@TK2MSFTNGP12.phx.gbl... >>>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 >>> >> >> > >
Don't see what you're looking for? Try a search.
|
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |