Rabu, 23 Oktober 2013

PHP Indonesia - Facebook: [tanya] tabel A. --------------------- | kode_A | ...

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/ 
Learning HTML & CSS shouldn't be difficult.

Master Trainer, Mark Lassoff, will teach you everything you need to know to create a creative and professional web site in 4 hours.
From our sponsors
[tanya] tabel A. --------------------- | kode_A | ...
Oct 23rd 2013, 16:33, by Indra Syafi'i

Indra Syafi'i 4:33pm Oct 23
[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 |
--------------

Andy Wijaya 4:43pm Oct 23
SELECT A.kode_A, nama FROM A LEFT JOIN B ON A.kode_A = B.kode_A WHERE nilai IS NULL
CMIIW

Leonard Luangga 4:46pm Oct 23
SELECT A.kode_A, A.nama
FROM A INNER JOIN B
ON A.kode_A=B.kode_A
WHERE B.nilai IS NULL

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar