Rachmat, I also noted that one of your queries includes: time_to_sec(timediff(akhir1.End, awal1.Begin))
I think time conversion routines are part of each database vendor's implementation -- and not part of the sql standard, so you'll need to convert to the time routines provided in sqlite or write your own functions. "Rachmat Febfauza" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > i have query that don't work in sqlite but in mysql work and make good > result. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users