[SQL] How to merge two tables into one ?

Hi all,

i have two tables structured like this :

Table policy

	Id
	Number
	Customer
	Adress
Table Commentary
	Id (foreign key references policy.Id)
	LineNumber
	Comment

I want to have one table :
table PolicyNew

	Id
	Number
	Customer
	Adress
	Comment

Where "Comment" is the concatenation of all the "Comment" fields in table Commentary where Policy.Id = Commentary.Id

Can someone help me writing this script ?

TIA, Zahi         

--
Zahi Al-Jamous e-mail: aljamous_at_crv.pechiney.fr Groupe GIL
Pechiney-CRV

BP 27				tel (work): +33.(0)4.76.57.82.45
F-38340 Voreppe			tel (cell): +33.(0)6.14.55.16.88