1. main table : phone_spec – 1

2. sub table : phone_color – n(多)

3. group_concat 사용

select
group_concat(t2.colorname SEPARATOR ‘||’) as c_colorname,
group_concat(t2.DVIC_CLR_IMGE SEPARATOR ‘||’) c_DVIC_CLR_IMGE,
t1.* from phone_spec as t1 , phone_color as t2
where t1.sid = t2.psid
group by t2.psid