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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement