Contoh :
Select usr.kode, usr.nama, mbl.jenis From (select kode, nama from tb_user) usr, (select kode, jenis from tb_kendar...@srv_01) mbl Where Mbl.kode = usr.kode Kira2 gini, maaf kalo ada kurang2, soalnya ngetiknya langsung di email. Untuk database yg berbeda bisa pake dblink => tb_kendar...@srv_01, dimana @srv_01 adalah dblink-nya thx, Regards =================== Bodhi Adhithana ==================== From: [email protected] [mailto:[email protected]] On Behalf Of oLa Sent: Thursday, February 04, 2010 3:30 PM To: [email protected] Subject: [indo-oracle] ???? Query Bagaimana cara menampilkan data yang terdiri dari 2 buah table dan 2 buah database yang berbeda mohon pencerahannya oL@ [Non-text portions of this message have been removed] Privileged/confidential information may be contained in this message. If you are not the named recipient or addressee, you are hereby notified that any use review, disclosure or copying of the contents herein is strictly prohibited. In such a case, kindly discard all its contents and notify sender accordingly regarding such unauthorized disclosure or transmission by email. Opinions, conclusions, statements and other information in this message that do not relate to the official business of CIMB Group shall be understood as neither given or endorsed by it. The contents herein are meant strictly for the use of the named recipient or addressee of CIMB Group. No assumption of responsibility or liability whatsoever is undertaken by CIMB Group in respect of prohibited and unauthorised use by any other person. [Non-text portions of this message have been removed]
