Prev: sql200 SQLSERVERAGENT service won't start
Next: Installing Visual Studio Express 2010 and SQL Express R2
From: roberta on 17 May 2010 17:35
Hi, I've 2 linked tables (Persona and Attivita)


Persona.ID
Persona.Descrizione

Attivita.ID
Attivita.Descrizione

PersonaAttivita.IDPersona
PersonaAttivita.IDAttivita


Each "Persona" can have X "Attivita"


I would like to create a SELECT that allow me to show for each "Persona"
X Attivita but in a single field

Something like this... 2 fields in a single record:

Persona.Descrizione:
"Mario Rossi"

A list of Attivita.Descrizione (for example separated by -)
"Attivita1 - Attivita2 - Attivita3"

Is it possible?

Thanks
 | 
Pages: 1
Prev: sql200 SQLSERVERAGENT service won't start
Next: Installing Visual Studio Express 2010 and SQL Express R2