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.
Next
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