[Combine multiple columns] #sql

sample.md

SELECT GROUP_CONCAT(name SEPARATOR '\n') as name, GROUP_CONCAT(value SEPARATOR '\n') as value
FROM `ach_wsal_metadata` meta
LEFT JOIN `ach_wsal_occurrences` oc
ON oc.id = meta.occurrence_id
GROUP BY occurrence_id

select t.teamname,
 concat(p.FirstNameId, ' ', p.LastNameId) teamMembers
from teams t
left join teammembers m
  on t.teamid = m.teamid
left join people p
  on m.peopleid = p.peopleid;

select something + somethingElse as onlyOneColumn from someTable

SELECT CONCAT(field1, field2) AS WHOLENAME FROM TABLE
WHERE ...

• https://ubiq.co/database-blog/concatenate-multiple-rows-one-column-mysql/
• https://stackoverflow.com/questions/13260046/mysql-combine-multiple-row-values-into-single-column
• https://stackoverflow.com/questions/5340064/select-2-columns-in-one-and-combine-them