are you know about this... ??

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

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