Query GROUP BY
Each client may have more than one MatterID associated with it. I would like to display the client name only once. Can this be done in a query?
Example:
Henry Winkler 555125147
478554425
154895522
Tom Jones 1425784111
Melissa Gilbert 4158234599
Alicia Keys 9235487444
2233654788
Example:
Henry Winkler 555125147
478554425
154895522
Tom Jones 1425784111
Melissa Gilbert 4158234599
Alicia Keys 9235487444
2233654788
SELECT c.FullName, m.MatterID
FROM CONTACTS C
JOIN MattersContacts MC ON C.CONTACTS = MC.Contacts
JOIN MATTERS M ON M.MATTERS = MC.Matters
JOIN MattersQADVISORS MQA ON M.Matters = MQA.Matters
Last Comment
Éric Moreau
This is the job of the viewing/reporting tool. SQL is there to spit data!
unless you want to concatenate your values into a single field: http://emoreau.com/Entries/Blogs/2009/10/SQL-Concatenate-values-multiple-from-multiple-lines.aspx
Éric is correct. I think the SSRS property name is 'Hide Duplicates', not sure about other reporting applications.
The role of the database is to store and execute queries in a timely manner.
The role of a reporting applicaiton is to take that data and render it in a cosmetically appealing way, and this question is about cosmetics.
The role of the database is to store and execute queries in a timely manner.
The role of a reporting applicaiton is to take that data and render it in a cosmetically appealing way, and this question is about cosmetics.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
