wow... bagus nih lebih ringkes nambah ilmu deh jadinya, tapi ada yang kelewat
bos..ini saya benerin dikit yeee
select nvl(table_1.A,table_2.A) a,table_ 1.B, table_1.C,table_ 2.D,table_ 2.E
from table_1
full outer join table_2
on table_1.A=table_ 2.A
Thx
ATL
--- On Thu, 4/22/10, Rudy W Sitanggang <[email protected]> wrote:
From: Rudy W Sitanggang <[email protected]>
Subject: Re: [indo-oracle] newbie tanya query..
To: [email protected]
Date: Thursday, April 22, 2010, 10:43 AM
Ini namanya full outer join.
Ini contohnya:
select table_1.A,table_ 1.B, table_1.C,table_ 2.D,table_ 2.E
from table_1
full outer join table_2
on table_1.A=table_ 2.A
Semoga membantu. :)
Warm regards,
Rudy Wardhany
Yahoo ID: rudy_staredge@ yahoo.com
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
