hehe, ribet juga ya.... dicoba dulu, thanks berat...
2010/8/4 tri afirianto <[email protected]> > > > 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]<indra.e00%40gmail.com>> > wrote: > > From: indra syafruddin <[email protected] <indra.e00%40gmail.com>> > Subject: [indo-oracle] tanya query right join > To: [email protected] <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] 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/
