PHP Indonesia - Facebook | PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ | |
|
[tanya] tabel A. --------------------- | kode_A | ... Oct 23rd 2013, 16:33, by Indra Syafi'i | [tanya] tabel A. --------------------- | kode_A | nama | | 1 | andi | | 2 | sakir | | 3 | ahmad | -------------- tabel B. ------------------------------- | kode_B | kode_A | nilai | | A1 | 3 | 80 | ----------------- **Pertanyaan** saya ingin menampilkan nama yg belum dapet nilai, query na gimana yah? Makasih yg udah bantu. --------------------- | kode_A | nama | | 1 | andi | | 2 | sakir | -------------- |
| | SELECT A.kode_A, nama FROM A LEFT JOIN B ON A.kode_A = B.kode_A WHERE nilai IS NULL CMIIW |
| | SELECT A.kode_A, A.nama FROM A INNER JOIN B ON A.kode_A=B.kode_A WHERE B.nilai IS NULL | | |
|
Tidak ada komentar:
Posting Komentar