Hi,
I've these tables:

tab1:
ID
1
2
3

tab2:
ID..........APPROV
1............A1
1............A2
2............A22
2............A34
2............A44
3............AAA

I'd like to ge this output:
ID...........APPROV
1............A1, A2
2............A22, A34, A44
3............AAA


How can I write my query to get this output?

Thanks!