1. main table : phone_spec – 1 2. sub table : phone_color – n(多) 3. group_concat 사용 select group_concat(t2.colorname SEPARATOR ‘||’) as c_colorname, [...]