tipe data tblnama.jp ama tipe data tblgp.jp apa..?
beda kali..
--- kennis kendrasti <[EMAIL PROTECTED]> wrote:
> Coba bantu jawab ya...
> Ini pakai ms Acces khan ? Kalau tidak mau pusing ya
> bikin saja pakai fasilitas create query in design
> view-nya access, klik query -> new -> Design view ->
> waktu muncul window show table double klik table2
> yang ingin di query tblnama, tblgr, tblgp , lalu
> tarik field dari table yang ingin di join, mis field
> jp tbl nama disambungkan dengan field jp tblgp
> caranya sama dengan buat relationship table, kalau
> sudah jadi tinggal buka view sql syntaxnya dan copy
> ke VB, simple kan ? (Cmiiw)
>
>
> milist MSD <[EMAIL PROTECTED]> wrote:
> Mas wawan, terima kasih atas penjelasannya.
> Setelah saya tambahkan kedua field di bagian group
> by, muncul error
> sbb :
> "Type mismatch in expression" (3615)
>
> Wah desperate saya nih huehehehe...
>
> Mungkin untuk lebih memperjelas maksud saya, berikut
> saya tampilkan
> full sql dan databasenya.
>
> SQL:
> SELECT nama, tblgr.kodegr AS kode, tblgp.honor AS
> honor
> FROM tblnama INNER JOIN tblgr ON
> tblnama.kode=tblgr.idxgr
> INNER JOIN tblgp ON tblnama.jp=tblgp.jp
> GROUP BY tblnama.nama, tblgr.kodegr, tblgp.honor
>
> DATABASE:
> tblnama
> kode nama jp
> 2 aaaa 2
> 3 bbbb 3
> 3 cccc 2
> 3 dddd 1
> 2 eeee 0
>
> tblgr
> idxgr kodegr
> 1 level 1
> 2 level 2
> 3 level 3
> 4 level 4
>
> tblgp
> kodegr jp honor
> level 1 0 0
> level 1 1 1000
> level 1 2 3000
> level 1 3 7000
> level 1 4 20000
> level 2 0 0
> level 2 2 30000
> level 2 3 70000
> level 3 0 0
> level 3 1 100000
> level 3 2 300000
> level 3 3 700000
>
> Dengan perintah SQL diatas, saya mengharapkan output
> SQL sbb :
>
> Nama Kode Honor
> aaaa level 2 30000
> bbbb level 3 700000
> cccc level 3 300000
> dddd level 3 100000
> eeee level 2 0
>
> Mohon petunjuk dan wejangan rekan2 sekalian, serta
> koreksi syntax SQL
> diatas, dan apakah desain tabel sudah efektif...
> Atas petunjuk rekan2 yang berharga saya ucapkan
> banyak2 terima kasih.
>
> Matur Nuwun,
> Best regards,
> Darmawan
>
>
> PVyc> Message: 16
> PVyc> Date: Mon, 3 Oct 2005 12:25:48 +0800
> PVyc> From: Purwedi Kurniawan
> <[EMAIL PROTECTED]>
> PVyc> Subject: Re: Re: SQL: Access tidak mendukung
> "join" antar tabel ???
>
> PVyc> cmmiw, error itu terjadi karena kita tidak
> PVyc> mengikutsertakan kode dan honor
> PVyc> di aggregate function, disini dalam Group By.
> jadi tinggal kita tambahkan
> PVyc> aja kedua field itu di bagian group by
> PVyc> group by nama, tblgr.kodegr, tblgp.honor
>
>
>
> Untuk keluar dari millis ini, kirim email kosong ke:
> [EMAIL PROTECTED]
>
>
>
>
>
> 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.
>
>
> ---------------------------------
>
>
>
>
> ---------------------------------
> Yahoo! for Good
> Click here to donate to the Hurricane Katrina
> relief effort.
______________________________________________________
Yahoo! for Good
Donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
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/
