Grouping and SQL - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Grouping and SQL

Message

From

26/10/2004 10:06:15

All

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Grouping and SQL

Environment versions

Visual FoxPro:

VFP 7 SP1

OS:

Windows XP SP2

Network:

Windows 2000 Server

Database:

Visual FoxPro

Miscellaneous

Thread ID:

00954532

Message ID:

00954532

Views:

I have a table that contains the following fields (in addition to other fields):

Jobno   Drwno
6378     1
6378     2
6378     3
6390     1
6390     2
etc....

Is there an SQL statement that would produce the following fields:

Jobno     Drwstring
6378      1,2,3
6390      1,2
etc....

Can this be done with the 'Group By' command? If so, how?

Thanks in advance for your help!