BrenoAguiar
IS-IT--Management
I have a table that looks like this:
ID Name unit
1 john 104
2 Mary 301
2 Mary 302
3 Carl 405
3 Carl 407
3 Carl 409
And I was wondering If I can combine the "unit" field values, in another table/query that would show:
ID Name unit
1 john 104
2 Mary 301, 302
3 Carl 405, 407, 409
Any thouhgts?
ID Name unit
1 john 104
2 Mary 301
2 Mary 302
3 Carl 405
3 Carl 407
3 Carl 409
And I was wondering If I can combine the "unit" field values, in another table/query that would show:
ID Name unit
1 john 104
2 Mary 301, 302
3 Carl 405, 407, 409
Any thouhgts?