PHP Indonesia - Facebook: [TANYA] saya mau update table dengan multiple tab...

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/

All Tech news in ONE place Tired of browsing thru hundreds of RSS feeds? Try Techi. All the tech news from around the web in ONE place, including exclusive articles. Daily newsletter. From our sponsors

[TANYA] saya mau update table dengan multiple tab... Sep 27th 2013, 05:43, by Mohamad Wildannudin Mohamad Wildannudin 5:43am Sep 27 [TANYA] saya mau update table dengan multiple table join. tpi menurut link ini http://dev.mysql.com/doc/refman/5.0/en/update.html "For the multiple-table syntax, UPDATE updates rows in each table named in table_references that satisfy the conditions. In this case, ORDER BY and LIMIT cannot be used. " ini query saya update data_rata inner join data_pilihan on data_rata.nomor_pendaftaran=data_pilihan.nomor_pendaftaran inner join kuota on data_pilihan.kode_program_studi=kuota.kode_prodi set data_rata.accepted_in='372221' where data_pilihan.kode_program_studi='372221' and data_pilihan.urutan_program_studi='1' order by data_rata.nilai desc limit 10 (kalau tanpa order by dan limit worked well) kira2 gmn dengan kasus begini??

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