| ya kurang lebih tinggal dibuat semacam:
SELECT nama,email, GROUP_CONCAT(link) AS link FROM A GROUP BY nama,email
.. tergantung kebutuhan berikutnya utk apa, kalo semisal dibuat:
SELECT nama, email, IF(link='kaskus',link,'') AS source1, IF(link='google',link,'') AS source2, IF(link='detik',link,'') AS source3 FROM A GROUP BY nama,email
cmiiw ^_^V |
Tidak ada komentar:
Posting Komentar