ilustrasi : table barang, fieldnya: kodebarang, namabarang table jenisbarang, fieldnya: kodejenisbarang, jenisbarang
table transaksi, fieldnya: namapembeli, kodebarang querynya: select a.namapembeli, b.kodebarang, c.jenisbarang from transaksi a, barang b, jenisbarang c where a.kodebarang = b.kodebarang and left(b.kodebarang,1) = c.kodejenisbarangbarang cmiiw --- In [email protected], "Joko" <[EMAIL PROTECTED]> wrote: > > > Gimana ya caranya menggunakan fungsi if dan(right, left atau mid) kayak > di Microsoft Excel. > Misalnya mencari Jenis Barang berdasarkan kode seperti dibawah ini : > > Kode Barang Jenis Barang > A Polpen > B Buku > C Pensil > > Nama Pembeli Kode barang Jenis barang > Somebody B2004 > Nobody A2004 > Bodyne Asyik C2005 > > Gimana ya rumus untuk mengisi Jensi Barang..? > > Thank Before. > Jack not The Jak but Liverpudlian > 9632100029 ------------------------ Yahoo! Groups Sponsor --------------------~--> DonorsChoose.org helps at-risk students succeed. Fund a student project today! http://us.click.yahoo.com/G7lQgA/FpQLAA/HwKMAA/x3XolB/TM --------------------------------------------------------------------~-> ================> HAPUS IKLAN DIATAS DAN FOOTER INI JIKA ME-REPLY <================ Posting : [email protected] Archive : http://www.mail-archive.com/[email protected]/ www.mitek.unibraw.ac.id || himamitek.brawijaya.ac.id ************************************************************************************ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/mitek/ <*> 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/
