On Apr 16, 2012, at 9:09 PM, Kit wrote: > SELECT doc.record, t.rec FROM doc LEFT JOIN t ON doc.id=t.doc_id > WHERE doc.id=id_xx AND created_on<=time_xx > ORDER BY created_on DESC LIMIT 1;
- how do you represent deleted rows? - how do you avoid version ambiguities (e.g. two rows created with the same timestamp)? _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
