Grouping and SQL - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Grouping and SQL

Message

26/10/2004 10:06:15

Tous

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Grouping and SQL

Versions des environnements

Visual FoxPro:

VFP 7 SP1

OS:

Windows XP SP2

Network:

Windows 2000 Server

Database:

Visual FoxPro

Divers

Thread ID:

00954532

Message ID:

00954532

Vues:

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!