Maaf ..., ada yg tau ekuivalennya Sql ini mysql : SELECT CONTACT.ADDRESS1, CONTACT.ADDRESS2, CONTACT.ADDRESS3, CITY.CONTENT, CONTACT.ZIPCODE_ID, PROVINCE.CONTENT, COUNTRY.CONTENT, CONTACT.WORKPHONE_INTCODE,CONTACT.WORKPHONE_NUMBER,CONTACT.WORKPHONE_EXT, CONTACT.WORKFAX,CONTACT.HOMEPHONE_INTCODE, CONTACT.HOMEPHONE_NUMBER, CONTACT.HOMEFAX, CONTACT.MOBILEPHONE, CONTACT.PAGER, CONTACT.EMAIL, CATEGORY.CONTENT FROM contact_detail CONTACT, m_city CITY, m_province PROVINCE, m_contact_category CATEGORY, m_country COUNTRY WHERE CONTACT.CITY_ID=CITY.CITY_ID(+) AND CONTACT.PROVINCE_ID=PROVINCE.PROVINCE_ID(+) AND CITY.PROVINCE_ID(+)=CONTACT.PROVINCE_ID AND CONTACT.CATEGORYCONTACT_ID=CATEGORY.CATEGORYCONTACT_ID(+) AND CONTACT.COUNTRY_ID=COUNTRY.COUNTRY_ID(+) AND CONTACT.EMPLOYEEID= ? AND CONTACT.CATEGORYCONTACT_ID= ? ;
Thanks .., Wildan -- ************************************************* "Choose a job you love, and you will never have to work a day in your life." -- Confucius ------ YM! : hawking_123 MSN : stephenhawking HP : 08561124986 http://wildanm.fisika.ui.edu ------ Dept. of Physics | Cisco Networking Academy Univ. of Indonesia | Program Depok | Telp. 021-9205371 | | http://labkom.fisika.ui.ac.id ************************************************* [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.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/
