Can I eliminate this problem by using function strftime('%s',timestampevar)
it try to rewrute:
select * from JX, JX_lim lim1 where lim1.rowid = (
select rowid from JX_lim lim2
where strftime('%s',lim2.edittime) <= strftime('%s',JX.starttime)
order by lim2.edittime desc limit 1
it is correct?
--
View this message in context:
http://old.nabble.com/joint-two-table-tp33228376p33245195.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
