Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combining multiple rows in one

Status
Not open for further replies.
jfokas

jfokas

Programmer
Apr 28, 2002
42
0
0
Sorry for asking a redundant question; I've the solution on the forum before but I can't seem to find the thread I need.

I need to combine results of query that returns multiple rows into a single comma delimited row.

SELECT name
FROM data_tmplt
WHERE yada yada yada

will give an output of

ROW1
ROW2
ROW3

I want to get this in the form of

ROW1, ROW2, ROW3

Can you help me get there.

Thanks for the help,

John
 
Sort by date Sort by votes
Look here: thread183-1159740

If you have any additional questions, ask them here.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
226
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
132
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
79
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question
How to export 20 milion rows to only one file ?
Replies
2
Views
71
JeffModen
JeffModen
Brianfree
  • Locked
  • Question
return unique rows only
Replies
11
Views
105
Brianfree
Brianfree

Part and Inventory Search

Sponsor

Back
Top