tabel a dan table b ada relasi nya gak ? kalau ada dan datanya ada yg sama , pake inner join
kalau gak ada yg sama bakalan binung :
Pakai inner join --> gak ada hasilnya
pakai left,right,cross --> bakalan 9
Btw : kalau datanya cuma 3, coba tampilkan saja disini, kemudian hasil yg di inginkan apa?
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| "Eko" <[EMAIL PROTECTED]>
Sent by: [email protected] 31/05/2006 09:20 AM
|
|
saya sudah masuk SQL , wong saya testingnya di MySqL Front
semua model join sudah saya pake, tapi hasilnya tetap 9 record
klo saya tambahin distinct cuma berkurang jadi 6 record
padahal pinginnya Tabel A (3 record) join Tabel B (3 record) hasilnya tetap 3 record
----- Original Message -----
From: dodik setiawan
To: [email protected]
Sent: Tuesday, May 30, 2006 4:55 PM
Subject: RE: [Programmer-VB] join 2 table masing2 3 record
Sudah coba masuk SQL dan di DISTINCT
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Eko
Sent: Tuesday, May 30, 2006 16:13
To: [email protected]
Subject: [Programmer-VB] join 2 table masing2 3 record
Gimana ya caranya join 2 table yang masing2 terdiri dari 3 record
tapi hasilnya tetap 3 record
saya coba pake inner/left/right join kok hasilnya selalu 9 record
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.
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.
