Hi, i have a select stamement which holds two dates, something like: 2011-12-31 09:00 2011-12-30 21:00 2011-12-31 18:00 2011-12-31 06:00 ...
let me call this t. and a table 'foods' which also holds a 'time' column and i now want to know all entries in foods which time is between one of the times in t. my approach was: select time, datetime(time, '-4 hours') from symptoms as t; select id from food where time between any t; but this gives me an error. Thanks for your help! Tobias -- View this message in context: http://old.nabble.com/help-with-a-query-using-between-with-a-select-staement-tp31878758p31878758.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
