select Z.A, Z.B, Z.C, ZZ.D, ZZ.E from table 1 Z, table 2 ZZ
________________________________ Dari: sefrinaldi <[email protected]> Kepada: [email protected] Terkirim: Jum, 16 April, 2010 09:38:18 Judul: [indo-oracle] newbie tanya query.. pagi, mau tanya query donk, maklum masih cupu :D saya punya 2 tabel, tabel 1 : *| A | B | C |* | 1 | X | Y | | 2 | T | U | tabel 2 : *| A | D | E |* | 1 | Q | W | | 3 | P | R | nah saya pengen gabungin kedua tabel itu sehingga kolomnya menjadi : *| A | B | C | D | E |* | 1 | X | Y | Q | W | | 2 | T | U | - | - | | 3 | - | - | P | R | jadi semua record field 'A' di tabel 1 dan table 2 di tampilin.. mohon petunjuknya, . Salam, .aldi [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
