Thanks it work.
I don't know that sqllite save TIMESTEMP as string, problem is with
counting i have to use helpful function
like as strftime('%s',timestampevar) .. but ... comparative operator <> =
BETWEEN is right.
Thanks
Igor Tandetnik wrote:
>
> ...
> You probably want something like
>
> select * from JX, JX_lim lim1 where lim1.rowid = (
> select rowid from JX_lim lim2
> where lim2.edittime <= JX.starttime
> order by lim2.edittime desc limit 1
> );
>
> But first you'd need to address the issue with data format that Simon
> pointed out. The way you have it, comparisons won't work right.
> --
> Igor Tandetnik
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/joint-two-table-tp33228376p33241938.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
