Ane dapet tugas ni gan, kalo pake excel kelihatan simple banget nih screen shotnya :


ane punya database namanya member isinya kayak gini :


itu cuma contoh doang ya gan

ane coba bikin query biar tampak seperti diexcelnya :

SELECT id_member AS ID, nama_member AS 'Nama Member', id_upline AS 'ID Upline' FROM member UNION SELECT nama_member as 'Nama Upline' FROM member WHERE id_upline = id_member ;


hasilnya query error, emang sih bisa dibikin query 2 kali, tapi ane pengen yang beda, tolong para master web bantu cari jalan keluarnya