ikut jawab ya :) klo begini gimana :
Select a.system, a.tanggal, b.parameter, a.nilai from pengukuran a, parameter b where a.SYSTEM = b.SYSTEM and a.parameter=b.parameter; saya udah coba, hasilnya kluar. Saya coba juga query Select a.system,a.tanggal,b.parameter, a.nilai from pengukuran a right join parameter b on (a.system = b.system and a.parameter=b.parameter) hasilnya keluar juga, mungkin value pada kolom ada yang ngandung spasi yang seharusnya 'A' malah 'A ' Semoga membantu, salam firman > y mungkin ada yang lebih sederhana... > ayo sapa sapa??? > > --- On Wed, 8/4/10, indra syafruddin <[email protected] > <mailto:indra.e00%40gmail.com>> wrote: > > From: indra syafruddin <[email protected] > <mailto:indra.e00%40gmail.com>> > Subject: Re: [indo-oracle] tanya query right join > To: [email protected] <mailto:indo-oracle%40yahoogroups.com> > Date: Wednesday, August 4, 2010, 1:54 AM > > hehe, ribet juga ya.... dicoba dulu, > > thanks berat... > > 2010/8/4 tri afirianto <[email protected] > <mailto:bejita_lun%40yahoo.com>> > > > > > > > Mas Indra, > > > > Ini ada query yang mungkin agak membingungkan ^^ > > > > SELECT a.SYSTEM,b.TANGGAL,a.PARAMETER, > > CASE WHEN c.NILAI IS NULL THEN '0' > > ELSE c.NILAI END CASE FROM PARAMETER a > > LEFT JOIN ( > > SELECT DISTINCT TANGGAL,x.SYSTEM FROM PARAMETER x > > LEFT JOIN PENGUKURAN y ON (x.SYSTEM=y.SYSTEM AND > x.PARAMETER=y.PARAMETER) > > ) B ON (a.SYSTEM=b.SYSTEM) > > LEFT JOIN PENGUKURAN C ON (a.SYSTEM=c.SYSTEM AND a.PARAMETER=c.PARAMETER > > AND b.TANGGAL=c.TANGGAL) > > ORDER BY a.SYSTEM,TANGGAL > > > > silakan dicoba.... > > > > Terimakasih, > > Afi > > > > --- On Wed, 8/4/10, indra syafruddin <[email protected] > <mailto:indra.e00%40gmail.com><indra.e00%40gmail.com>> > > wrote: > > > > From: indra syafruddin <[email protected] > <mailto:indra.e00%40gmail.com> <indra.e00%40gmail.com>> > > Subject: [indo-oracle] tanya query right join > > To: [email protected] > <mailto:indo-oracle%40yahoogroups.com> <indo-oracle%40yahoogroups.com> > > Date: Wednesday, August 4, 2010, 1:04 AM > > > > > > > > > > Dear all, > > > > saya ada masalahan dengan query. Kondisinya, dalam satu sistem terkadang > > ada > > > > parameter yang tidak terambil, untuk tanggal tertentu. Untuk > > > > parameter-parameter yang belum diambil tersebut, saya membutuhkan untuk > > > > diberi nilai 0 atau null. > > > > tabelnya seperti ini : > > > > Pengukuran > > > > System Tanggal Parameter Nilai > > > > A 1/2/2010 arus 45 > > > > A 1/2/2010 daya 200 > > > > A 1/2/2010 tegangan 220 > > > > A 1/3/2010 Arus 44 > > > > A 1/3/2010 Tegangan 220 > > > > B 1/2/2010 Arus 30 > > > > B 1/2/2010 Hambatan 30 > > > > B 1/2/2010 Daya 50 > > > > B 1/3/2010 Arus 35 > > > > B 1/3/2010 Hambatan 55 > > > > saya butuh hasil seperti ini : > > > > System Tanggal Parameter Nilai > > > > A 1/2/2010 arus 45 > > > > A 1/2/2010 daya 200 > > > > A 1/2/2010 tegangan 220 > > > > A 1/3/2010 arus 44 > > > > A 1/3/2010 daya 0 > > > > A 1/3/2010 tegangan 220 > > > > B 1/2/2010 Arus 30 > > > > B 1/2/2010 Hambatan 30 > > > > B 1/2/2010 Daya 50 > > > > B 1/3/2010 Arus 35 > > > > B 1/3/2010 Hambatan 55 > > > > B 1/3/2010 Daya 0 > > > > saya sudah buat tabel parameter untuk right join : > > > > System Parameter > > > > A arus > > > > A daya > > > > A tegangan > > > > B Arus > > > > B Hambatan > > > > B Daya > > > > kemudian query : > > > > Select a.system,a.tanggal,b.parameter, a.nilai from pengukuran a > right join > > > > parameter b on (a.system = b.system and a.parameter=b.parameter) > > > > tapi hasilnya tidak keluar sesuai yang diharapkan (parameter tidak > keluar > > di > > > > semua tanggal) > > > > [Non-text portions of this message have been removed] > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] > > ------------------------------------ > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [email protected] > <mailto:indo-oracle-unsubscribe%40yahoogroups.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] > > ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
