Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL challenge
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
SQL challenge
Divers
Thread ID:
00083158
Message ID:
00083158
Vues:
64
I am trying to solve a problem using only SQL in VFP3.0b

I have a table that is has the following structure:

STAFFID
LANGUAGE

Which represents the languages that a staff member speaks. If a staff member speaks more than one language they have more than one record in the table.

I would like to collapse this into one record for each staff member by putting all the languages that a staff memeber speaks into one field (for formatting purposes in a report). The structure of the new table thus becomes:

STAFFID
LANGUAGES

The answer obviously uses a self join... but beyond this I am stumped.
I don't care how many nested Selects or intermediate selects there are.

If anyone has any time, I would greatly appreciate it.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform