- Beranda
- Komunitas
- Tech
- Website, Webmaster, Webdeveloper
Multiple select dalam satu query (help me!)
![Benny-K](https://s.kaskus.id/user/avatar/2008/02/22/avatar405789_4.gif)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
TS
Benny-K
Multiple select dalam satu query (help me!)
Ane dapet tugas ni gan, kalo pake excel kelihatan simple banget nih screen shotnya :
![Multiple select dalam satu query (help me!)](https://s.kaskus.id/images/2014/04/07/405789_20140407025749.jpg)
ane punya database namanya member isinya kayak gini :
![Multiple select dalam satu query (help me!)](https://s.kaskus.id/images/2014/04/07/405789_20140407025947.jpg)
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![Matabelo emoticon-Matabelo](https://s.kaskus.id/images/smilies/smilies_fb5ohtvdpjkq.gif)
![Multiple select dalam satu query (help me!)](https://s.kaskus.id/images/2014/04/07/405789_20140407025749.jpg)
ane punya database namanya member isinya kayak gini :
![Multiple select dalam satu query (help me!)](https://s.kaskus.id/images/2014/04/07/405789_20140407025947.jpg)
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
![Matabelo emoticon-Matabelo](https://s.kaskus.id/images/smilies/smilies_fb5ohtvdpjkq.gif)
Quote:
Diubah oleh Benny-K 08-04-2014 04:17
0
964
4
![Guest](https://s.kaskus.id/user/avatar/default.png)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
Komentar yang asik ya
Urutan
Terbaru
Terlama
![Guest](https://s.kaskus.id/user/avatar/default.png)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
Komentar yang asik ya
Komunitas Pilihan