troubleshooting Question

left join question .. is there another way ?

Avatar of Aleks
AleksFlag for United States of America asked on
Web DevelopmentASPSQL
8 Comments1 Solution223 ViewsLast Modified:
Ill try explain in simple terms.

Table A is Cases
The ID is id

Table B is CaseComments
The join would be in :  casecomments.caseid = cases.id

The thing is that for each case there might be several case comments, if I do a query and do a left join to case comments from cases then I will get one recordset for each comment, which is not what I need. What I need is to display all comments in a column. So that I end up with something like:

Caseid, case number, process, etc .. , [CASECOMMENTS] (All of them separated by a dash or whatever, in one column)
Next record &. Etc

Is it possible to do this with SQL ?

Appreciate your help.
ASKER CERTIFIED SOLUTION
D B
Database Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros