few days ago i try create application using c# and using database sqlite..
in some select, insert dan update working normally..
but i have some confuse about select and this not about the result row,
but header the result row
with this select
i got this
which i try using this select in my application i got error ...
and i try using this select too
and get result
and i try this in my desktop application it's working..
i don't know why only different in GROUP BY, header column changed...
any body know about this... ??
in some select, insert dan update working normally..
but i have some confuse about select and this not about the result row,
but header the result row
with this select
SELECT tbl_pasien.id,tbl_pasien.nama, tbl_pemeriksaan.id FROM tbl_pemeriksaan, tbl_pasien WHERE tbl_pasien.id = tbl_pemeriksaan.id
i got this
id nama id
---------- ---------- ----------
1 eka 1
4 4
which i try using this select in my application i got error ...
and i try using this select too
SELECT tbl_pasien.id,tbl_pasien.nama, tbl_pemeriksaan.id FROM tbl_pemeriksaan, tbl_pasien WHERE tbl_pasien.id = tbl_pemeriksaan.id GROUP BY tbl_pemeriksaan.tanggal;
and get result
tbl_pasien.id tbl_pasien.nama tbl_pemeriksaan.id
------------- --------------- ------------------
1 eka 1
4 4
and i try this in my desktop application it's working..
i don't know why only different in GROUP BY, header column changed...
any body know about this... ??
Comments
Post a Comment