atau
select a.* from tblmahasiswa a inner join
db_proses_belajar..tblnilaiujian b on a.nim=b.nim
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| mamadh <[EMAIL PROTECTED]>
Sent by: [email protected] 22/06/2006 03:38 PM
|
|
klo di sql server spt ini:
select * from dbo.dB_Registrasi_Pendidikan.tblMahasiswa a,
dbo.dB_Proses_Belajar.tblnilaiujian b
where a.nim = b.nim
klo di mysql, saya belum tahu.
ali suparman wrote:
> Salam buat para VBers,
> Mas-mas semua, gimana sih (atau mungkin ngga) membuat sintak SQL dari
> 2 tabel yang bersumber databasenya berbeda, misalnya:
> Tabel 1: tblMahasiswa dari DatabaseName 1: dB_Registrasi_Pendidikan
> Fieldnya: NIM(primary), Nama, Alamat,Dll
> Tabel 2: tblNilaiUjian dari DatabaseName 2 : dB_Proses_Belajar
> Fieldnya: NIM, Test1, Test2, NilaiAkhir.
> Anda ada yang sudah pernah membuat, wah saya berterimakasih sekali
> kalau kodenya sedikit ditulis, Thank banget
> Tambahan: Databasenya MySQL
>
> ------------------------------------------------------------------------
> Yahoo! Groups gets better. Check out the new email design.
> <http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=41142/*http://groups.yahoo.com/local/newemail.html>
> Plus there’s much more to come.
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Something is new at Yahoo! Groups. Check out the enhanced email design.
http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~->
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/
__._,_.___
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
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
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.
