coba : "Select Nama from (Select Nama from Tabel A union Select Nama from Tabel B) as QNama"
moga" membantu. ----- Original Message ---- From: Mahendra <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, June 2, 2008 3:43:44 PM Subject: [indoprog-vb] Query memangil 2 tabel dalam satu Fild Tolong saya ya ; Masih Belajar SQL Saya Ada dua Tabel Nama Table : Tabel A Fild : Nama Record : Budi Andi Nama Table : Tabel B Fild : Nama Record : Anton Joko sql nya Biar hailnya Nama Qry : QNama Fild : Nama Record : Budi Andi Anton Joko Gimana YA, Tanpa temporary Table Tks [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
