tinggal direname aja field nya waktu select. pasti bisa. select id_A as id , a.NIP as NIP from table_A union select id_B as id , b.kode as NIP from table_B
bs kan? ----- Original Message ---- From: Henry <[EMAIL PROTECTED]> To: [email protected] Cc: [EMAIL PROTECTED] Sent: Monday, August 27, 2007 2:02:32 PM Subject: Re: [BinusNet] Gabungin 2 recordset di VB Pokoknya 2 query itu gak bisa di join di query analyzer, atau pakai union karena fieldnya ada yang beda, sedang kalau union kau 2 table musti sama fieldnya. nah ini mau di proses di vb. ----- Original Message ----- From: Trianugraha S. To: [EMAIL PROTECTED] s.com Sent: Monday, August 27, 2007 1:43 PM Subject: Re: [BinusNet] Gabungin 2 recordset di VB sudah coba pake union query ? regards, trianugraha ----- Original Message ----- From: "Henry" <[EMAIL PROTECTED] t.co.id> To: <[EMAIL PROTECTED] s.com> Sent: Monday, August 27, 2007 1:25 PM Subject: [BinusNet] Gabungin 2 recordset di VB > Guys, ada yang tau gak caranya gabungin 2 recordset jadi 1 table di VB > > recordset1.open "select ....." > recordset2.open "select..... " > nah 2 recordset ini mau di gabungin, soalnya kalau langsung gabung dari > query pertama gak bisa, gitu lho > caranya gimana ya ???? > > Thanks > Henry > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] ____________________________________________________________________________________ Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz [Non-text portions of this message have been removed]
