coba ini mas, insert into validasi(sales_id,prod_id) select s.sales_id, s.prod_id from validator v,sales2 s where s.prod_id=v.prod_id order by s.sales_id asc,v.jumlah_muncul desc,v.prod_id desc
maaf saya posting aja, soalnya chat anda idle...sebelum insert coba dulu querynya (selectnya saja tanpa insert).. Regards Ferry S > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] > Behalf Of Yoel > Sent: 11 August 2006 09:28 > To: [email protected] > Subject: Re: [indo-oracle] Tanya kueri > > > kalo ingin urutannya sesuai urutan data di table SALES. > > select sales_id, prod_id > from sales > where prod_id in (select prod_id from validator) > > tanpa order by semestinya urutannya ikut dengan urutan data table sales. > tapi hanya tampilan prod_id yang ada di table validator. > coba dulu,sorry terus terang belum test sqlnya karena gak punya > data-nya :) > semoga berhasil. > > On 8/11/06, gede sudi <[EMAIL PROTECTED]> wrote: > > > > maksudnya urutan di tabel validasi mengikuti urutan data di > sales dengan > > ketentuan product yang muncul hanya yang memenuhi >=3 sesuai di tabel > > validator. -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> 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/
