select c.no_induk,a.[nama siswa],b.nm_bstudi as bstudi, c.nilai from siswa a, studi b, nilai c where c.no_induk = a.no_induk and c.kd_bstudi = b.kd_bstudi
atau select c.no_induk,a.[nama siswa],b.nm_bstudi as bstudi, c.nilai from nilai c inner join siswa a on c.no_induk = a.no_induk inner join studi b on c.kd_bstudi = b.kd_studi best regards [wwn] --- In [email protected], "skdmdn" <[EMAIL PROTECTED]> wrote: > > Teman2. > > Bagaimana perintah sql untuk relational database lebih dari 2 tabel. > Misalkan saya punya 3 tabel spt ini: > > > 1.TABEL SISWA > > NO_INDUK , NAMA SISWA > > 2. TABEL BIDANG STUDI > > KD_BSTUDI, NM_BSTUDI > > 3. TABEL NILAI > NO_INDUK, KD_BSTUDI, NILAI > > Saya ingin hasilnya spt ini: > > NO_INDUK NAMA SISWA BSTUDI NILAI > > Thank's atas bantuannya. > Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut: http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke: [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini: Yahoo! Messenger: wahanaprogrammer Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
