hmm. ini mesti diperjelas kali ya tujuan di join recordsetnya buat apa? recordset kedua buat edit yang pertama atao apa. kalo emang gitu si, buka satu-satu aja, buka recordset pertama trus update trus buka yang kedua untuk edit yang hasil update-an sebelumnya.
kalo memang tujuan joinnya untuk gabung query, lebih baik lewat sintax Sql nya. tapi jangan lupa 'union' atau 'union all' itu untuk tipe data yang sama. jadi kalo Date (walau sudah di-alias) trus di union dengan Integer, nanti resultnya jadi ga bener (diconvert ke date semua). mungkin bisa dispesific kasusnya Bung Hen.. ----- Original Message ---- From: Hendra Jr. <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, August 27, 2007 4:55:58 PM Subject: Re: [BinusNet] Gabungin 2 recordset di VB 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] t.co.id> To: [EMAIL PROTECTED] s.com Cc: [EMAIL PROTECTED] net.id 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] n t.co.id> To: <[EMAIL PROTECTED] p 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] ____________________________________________________________________________________ Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games. http://sims.yahoo.com/ [Non-text portions of this message have been removed]
