On Jun 19, 2011, at 12:06 PM, looki wrote: > 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.
for example: select foods.id from foods where exists (select 1 from symptoms where foods.time between symptoms.start_time and symptoms.end_time ) > but this gives me an error. Indeed, making up your own syntax is not going to fly. When in doubt, check the friendly instruction manual: http://www.sqlite.org/lang.html _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
