Concat table to one field
The senario is Order with the items in a 'Detail' table.
I have a need concat the detail (Quantity and Productname +crlf) into one
field and return it with a query of the Order table.
This is so I can have the order information and the detailed line items in
a text 'memo' field.
Otherwise you end up with multiple records when joining items and order tables.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center