SPECIAL QUERY

G

Guest

Hi everyone!
I have a problem with a table containing notes joined with
a document number, I would like to have for each doc
number just one note containing all the notes.
Hereunder you will find an example.

DOC_NR ID NOTES

10 001 trasporto....
10 002 magazzino....
10 003 qualità......
20 001 trasporto.......

hereunder you will find the result I would like to get.

10 trasporto... magazzino... qualità...
20 trasport...

Thank you in advance for your cooperation.

Christian
 
Top