| Author |
Message |
ricky_seldjatem |
| Location: |
|
Post subject: kenapa Ambiguous column name 'tgl'.
 Posted: 12/Jun/2008 14:10
|
|
onIntermediate
Joined: 14-Jan-2008
Posts: 43
Status: Offline
|
|
kenapa muncul pesan seperti ini : Ambiguous column name 'tgl'., kesalahannya diman ?
SELECT gaji.noslip,pegawai.nopeg,gaji.tgl, Year([tgl]) AS THN, Month([tgl]) AS BLN
FROM ((jabatan INNER JOIN pegawai ON jabatan.kd_jabatan = pegawai.kd_jabatan) INNER JOIN gaji ON gaji.nopeg = pegawai.nopeg) INNER JOIN pinjaman ON gaji.kd_pinjam = pinjaman.kd_pinjam
WHERE (((gaji.tgl) Is Not Null)); |
|
|
| |
|
|
|
 |
|
julius |
| Location: |
|
|
Post subject: RE: kenapa Ambiguous column name
Posted: 12/Jun/2008 14:22
|
|
onSkilled
Joined: 27-Nov-2006
Posts: 123
Status: Offline
|
|
kemungkinan kesalahan karena dua tabel atau lebih ada field dengan nama tgl.
sedangkan pada kolom yg di tampilkan (select) ada field tgl yg tidak di ketahui field tgl tsb milik tabel yg mana.
coba di cek, di situ udah keliatan jelas. ada field tgl tanpa di awali nama tabel  |
_________________
Tempat Nongkrong : http://nongkrong.in.ruangkopi.com/
|
| |
|
|
|
|
|
ricky_seldjatem |
| Location: |
|
|
Post subject: RE: kenapa Ambiguous column name
Posted: 12/Jun/2008 20:50
|
|
onIntermediate
Joined: 14-Jan-2008
Posts: 43
Status: Offline
|
|
terima kasih akhirnya bisa juga dengan syntaks : SELECT gaji.noslip,pegawai.nopeg,gaji.tgl, Year(gaji.tgl) AS THN, Month(gaji.tgl) AS BLN
FROM ((jabatan INNER JOIN pegawai ON jabatan.kd_jabatan = pegawai.kd_jabatan) INNER JOIN gaji ON gaji.nopeg = pegawai.nopeg) INNER JOIN pinjaman ON gaji.kd_pinjam = pinjaman.kd_pinjam
WHERE (((gaji.tgl) is not null)) |
|
|
| |
|
|
|
|
|
asepolin |
| Location: |
|
|
Post subject:
Posted: 07/Sep/2010 21:28
|
|
onConfident
Joined: 29-Jan-2009
Posts: 20
Status: Offline
|
|
|
|
|
|
|
|
|
|
