Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lemmy44
Starting Member
20 Posts |
 Posted - 2005-11-08 : 09:33:07
|
| I've been asked to write a query/produce a report from our client information database. What we have is a large SQL database that holds all of our client information. Some of the fields can have multiple choice answers. When I write the query, I get multiple results due to the possibility of having more than one answer associated with a client.Example (in case I haven't explained it correctly)Name Address DisabilityJoe Smith 123 Main St. AsbergesJoe Smith 123 Main St. AutismWhat I would like to do, is produce only one line for each client, listing all of the possible choices.Joe Smith 123 Main St. Asbergs, AutismI am fairly new to the SQL language, so I'm not sure if there is a method to doing this, and that I just have not come across it yet?Thanks,Lem |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
Lemmy44
Starting Member
20 Posts |
Posted - 2005-11-08 : 15:45:50
|
| Thanks for the info....you've got me on the right track anyways. |
 |
|
|
|
|
|
Merging Fields