Query...

  • Thread starter Thread starter Ivan Debono
  • Start date Start date
I

Ivan Debono

Hi ppl,

I have a main table A and a table B. I would to select all records in table
B that match their id in table A, but instead of having the results in a
list, I would like them comma separated in 1 line, example:

I have the following values:

Table A
1, Item 1
2, Item 2

Table B
1, 1, Monday
2, 1, Tuesday
3, 1, Wednesday
4, 2, Thursday
5, 2, Friday

My results after the query would be:

Item 1 Monday, Tuesday, Wednesday
Item 2 Thursday, Friday

Can I do it, and if yes, how??

Thanks,
Ivan
 
Back
Top