Rabu, 09 Oktober 2013

PHP Indonesia - Facebook: [Ask] Query SQL Untuk master-master query dimoho...

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/ 
Refresh your vocabulary.

Learn a new word everyday by subscribing to Word of the Day. A great tool if you're studying for the GRE, GMAT or LSAT, or simply want to enhance your lexicon.
From our sponsors
[Ask] Query SQL Untuk master-master query dimoho...
Oct 9th 2013, 13:01, by Ratu Diekey

Ratu Diekey 1:01pm Oct 9
[Ask] Query SQL

Untuk master-master query dimohon bantuannya.
Saya punya 3 tabel.
Tbl_Karyawan = nik, nama, alamat.
Tbl_Cuti = no_cuti, nik, keterangan, no_pengganti.
Tbl_pengganti = no_pengganti, nik.

Saya punya query.
select tbl_cuti.no_cuti,tbl_cuti.nik as Nik_Pencuti, tbl_karyawan.nama as Nama_Pencuti, tbl_cuti.keterangan,
tbl_pengganti.nik as Nik_Pengganti from tbl_cuti, tbl_karyawan, tbl_pengganti where tbl_cuti.nik = tbl_karyawan.NIK

Yang saya ingin tanyakan, bagaimana query untuk menampilkan / menambahkan nama_pengganti sesuai dengan nik_pengganti.

Endra Wijaya 1:10pm Oct 9
tabel penggati harusnya ada field no_cuti dan harus PK di tabel cuti

Ratu Diekey 1:13pm Oct 9
Jadi Begini ya mas Endra Wijaya
tbl_Karyawan = nik, nama, alamat.
Tbl_Cuti = no_cuti, nik, keterangan
Tbl_pengganti = no_pengganti, no_cuti, nik

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