kalo jumlah field sama, langsung aja :
select * from table_1
union
select * from table_2;
tapi kalo jumlah field beda :
select * from table_1
union
select *,'','' from table_2; (misal beda 2 field, table2 kurang 2 field, tambah karakter null ('') aja)
ChipMunks <[EMAIL PROTECTED]> wrote:
Bagaimana cara syntac union di acces..
saya mo gabungin 2 table yang isinya itu :
1. table 1 = 3 record
2. table 2 = 1 record
jadi di query dijadikan 4 record
thanks
thanks before...
Salam,
ChipMunks (Copy Paste Programmer)
mailto: [EMAIL PROTECTED]co.id
Yahoo : Henqy
Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail. __._,_.___
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
SPONSORED LINKS
| Indonesia phone card | Programmer | Indonesia tour |
| Indonesia travel | Indonesia flower |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
__,_._,___
