General information
Category:
Coding, syntax & commands
Hi Karl,
The format you are looking for can be considered a report. SQL is concerned with fetching data, not display. If you wanted a cursor to look like this, you need to post-process the data.
>Hi everyone, i have a general question about how to get a master list of records. For example, my recordset contains some info as follows:
>
>Name: Applications:
>John Smith Visual Foxpro
>John Smith Microsoft Office
>John Smith Photoshop
>
>I would like use a select statment to return the following info:
>
>John Smith, Visual Foxpro, Microsoft Office, Photoshop
>
>into one record.
>
>Can anyone help me?
>
>Thanx
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only