masalahnya yang ingin ditampilkan adalah: Price yang TERAKHIR dari tiap item, berdasarkan pada effective datenya dan item yang belum ada pricenya juga tampil. pake MSSQL Server, lho
thanks ya Om hto kol regards -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of hto kol Sent: Monday, November 06, 2006 10:49 AM To: [email protected] Subject: Re: [indopb] tanya outer join coba yang ini, semoga sukses : select itm.itm_code ,itm.itm_suplier , sp.sls_price from item_master itm left outer join sales_price sp on itm.itm_code = sp.sls_code where itm.itm_suplier = 'BBB' __________________________________________________ Apakah Anda Yahoo!? Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik terhadap spam http://id.mail.yahoo.com ----------------------------------------------- IndoPB - Indonesia PB User Group An Indonesian PowerBuilder User Group's Event 2nd PowerBuilder Update Rumah Sakit Jantung Harapan Kita 26/27 August 2006 To Register : http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4 Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indopb/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[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/
