Concat result of a sub-select in a single field
How can I concat all registers of a sub-select in a single field.
like:
SELECT DATE_MARK
FROM TABLE_A
WHERE COD = '123'
RESULT:
200601
200605
200607
200507
How can I put that result in a single field? like this:
'200601 200605 200607 200507'
Thanks.