Yandri
Yandri> syaratnya, jumlah field kedua table harus sama!!!
Yandri>
Yandri> kalo jumlah field sama, langsung aja :
Yandri> select * from table_1
Yandri> union
Yandri> select * from table_2;
Yandri>
Yandri> tapi kalo jumlah field beda :
Yandri> select * from table_1
Yandri> union
Yandri> select *,'','' from table_2; (misal beda 2 field, table2
Yandri> kurang 2 field, tambah karakter null ('') aja)
Yandri>
Yandri> ChipMunks <[EMAIL PROTECTED]> wrote:
Yandri> Bagaimana cara syntac union di acces..
Yandri>
Yandri> saya mo gabungin 2 table yang isinya itu :
Yandri> 1. table 1 = 3 record
Yandri> 2. table 2 = 1 record
Yandri>
Yandri> jadi di query dijadikan 4 record
Yandri> thanks
Yandri>
Yandri> thanks before...
Yandri>
Yandri> Salam,
Yandri> ChipMunks (Copy Paste Programmer)
Yandri> mailto: [EMAIL PROTECTED]
Yandri> Yahoo : Henqy
Yandri>
Yandri>
Yandri>
Yandri>
Yandri>
Yandri> ---------------------------------
Yandri> Do you Yahoo!?
Yandri> Get on board. You're invited to try the new Yahoo! Mail.
kalo di table 2 nya itu kurang jumlah fieldnya ?
Salam,
ChipMunks (Copy Paste Programmer)
mailto: [EMAIL PROTECTED]
Yahoo : Henqy
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
