Posted by Terren on 05/04/06 12:14

Is there a way to create one field from multiple records using sql.
For example

Table 1
John 18
Peter 18
David 18

Now I want an sql query that when executed will return a field that
looks like this

Query1
John Peter David

So basically it will return one record with all the name in one field

• Next in forum: Re: Partition function - Unknow range column
• Prev in forum: Re: Problems with view
• Thread view: Join multiple records into one field

[Reply to this message]