Re: [Programmer-VB] SQL: Access tidak mendukung "join" antar tabel ???

Thu, 29 Sep 2005 22:36:37 -0700

standar sql query, kalau join field udah diletakkan setelah WHERE, kita tidak perlu pake JOIN di depan FROM.
 
coba ubah jadi:
 
SELECT nama, tblgr.kodegr AS kode,
tblgp.honor AS honor
FROM tblnama, tblgr, tblgp WHERE
tblnama.kode=tblgr.idxgr AND
tblnama.jp=tblgp.jp
GROUP BY
tblnama.nama
 
kalau mau pake JOIN coba ubah jadi gini
 
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
 
kelebihannya, kita bisa memilih u. menggunakan Inner/Outer/Cross Left/Right Join
 
best regards
[wwn]
 
On 9/30/05, milist MSD <[EMAIL PROTECTED]> wrote:
Dear all,

Mohon tanya,
Saya coba query access dengan memanfaatkan perintah join, tapi
dibilangnya koq error, pas saya coba di mysql berhasil dengan baik.
Apa karena access tidak mendukung perintah join ???

SQLnya :
SELECT nama, tblgr.kodegr AS kode,
tblgp.honor AS honor
FROM tblnama
JOIN tblgr
JOIN tblgp WHERE
tblnama.kode=tblgr.idxgr AND
tblnama.jp=tblgp.jp
GROUP BY
tblnama.nama

Kalo db-nya access : error messagenya : Syntax error in FROM clause (3131).
Kalo db-nya mysql  : success.

Mohon koreksinya...
Makasih en wassalam,

Darmawan
-digestmode-


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



Kirim email ke