Salam Benar yang dikatakan wendi, RDBMS perlu di normalisasi dan query dibuat sederhana, sehingga lebih kecil costnya.
regards, On Wed, 23 Jun 2010 16:19:26 +0700 wendi gunawan <[email protected]> wrote: > klo ingin lebih cepat querynya.. > lalakun filter lebih awal..baru di union kan... > > > > 2010/6/22 Akah <[email protected]> > > > > > > > Yup setuju dengan bung Wadi, sebaiknya diperhatikan lagi normalisasinya. > > > > Oh iya kalau dibanding dengan > > > > SELECT * FROM > > > > (SELECT ID_COMPANY, CARA_BAYAR, BAYAR FROM HR.TABLE_A > > > > UNION SELECT ID_COMPANY, CARA_BAYAR, BAYAR FROM HR.TABLE_B > > > > UNION SELECT ID_COMPANY, CARA_BAYAR, BAYAR FROM HR.TABLE_C) X > > > > WHERE X.CARA_BAYAR='TUNAI' > > > > Costnya besaran mana ya bro? > > > > From: [email protected] <indo-oracle%40yahoogroups.com> [mailto: > > [email protected] <indo-oracle%40yahoogroups.com>] On > > Behalf Of Wadi Achmed > > Sent: Tuesday, June 22, 2010 5:51 PM > > To: [email protected] <indo-oracle%40yahoogroups.com> > > Cc: Aud Solehuddin > > Subject: Re: [indo-oracle] ask query SQL > > > > > > Pertama: Maaf, saya balik nanya. > > Kenapa tablenya ada 3 kalau atribut dan fungsinya sama semua? > > > > Solusinya: > > > > Kalau tablenya satu (nama table asumsi table_bayar): > > ------------------------------ > > Select id_company, bayar > > from table_bayar > > where cara_bayar = 'tunai'; > > > > Kalau masih maksa pake 3 table > > ------------------------------ > > select id_company, bayar > > from table_a > > where cara_bayar = 'tunai' > > union all > > select id_company, bayar > > from table_b > > where cara_bayar = 'tunai' > > union all > > select id_company, bayar > > from table_c > > where cara_bayar = 'tunai'; > > > > Sekali lagi saya sarankan diubah tablenya cukup satu aja. > > Coba pelajari lagi konsep normalisasi database. > > > > Cheers, > > Wadi Achmed > > > > On 6/22/2010 5:08 PM, Aud Solehuddin wrote: > > > Dear all, terimakasih sebelumnya, minta bantuan nyari query SQL untuk > > select dari table berikut : > > > > > > > > > > > > misal saya punya tiga table, > > > > > > > > > > > > table A > > > > > > id_company > > > > > > cara_bayar (tunai, bni, bca) > > > > > > bayar > > > > > > field lain2 > > > > > > > > > > > > table B > > > > > > id_company > > > > > > cara_bayar (tunai, bni, bca) > > > > > > bayar > > > > > > field lain2 > > > > > > > > > > > > table C > > > > > > id_company > > > > > > cara_bayar (tunai, bni, bca) > > > > > > bayar > > > > > > field lain2 > > > > > > > > > > > > contoh isian : > > > > > > table A > > > > > > > > > > > > PT Coba > > > > > > 200000 > > > > > > tunai > > > > > > > > > > > > table B > > > > > > PT Tes > > > > > > 500000 > > > > > > bni > > > > > > > > > > > > table C > > > > > > PT Sample > > > > > > 1000000 > > > > > > tunai > > > > > > > > > > > > hasil yang diharapkan (tampil yang tunai) : > > > > > > > > > > > > id_company bayar > > > > > > PT Coba 200000 > > > > > > PT Sample 1000000 > > > > > > > > > > > > bagaimana cara saya menampilkan id_company dan bayar, yang memiliki cara > > bayar ='tunai' > > > > > > > > > > > > makasih atas bantuannya semuanya.. :) > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > ------------------------------------ > > > > > > -- > > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > > Keluar: > > > [email protected]<indo-oracle-unsubscribe%40yahoogroups.com> > > <mailto:indo-oracle-unsubscribe%40yahoogroups.com<indo-oracle-unsubscribe%2540yahoogroups.com>> > > > > > Website: http://indooracle.wordpress.com > > > http://www.facebook.com/group.php?gid=51973053515 > > > ----------------------------------------------- > > > > > > Bergabung dengan Indonesia Thin Client User Groups, > > > Terminal Server, Citrix, New Moon Caneveral, di: > > > http://indo-thin.blogspot.comYahoo! Groups Links > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > Please consider the environment before print out this email > > =================================================================== > > ==This message was scanned by Toyota Tsusho Indonesia Email Server Anti > > Virus== > > =================================================================== > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > -- > wendi gunawan > Java Software Developer & penulis (new bie) > terus belajar untuk tidak cinta dunia > http://oretanwendi.wordpress.com/ > hp:085624046906 > > > [Non-text portions of this message have been removed] > -- natalandts <[email protected]>
