Re: [sqlite] Help with SQLite Query

Igor, That has worked perfectly. Thankyou very much for your assistance. Regards Andrew -- View this message in context: http://www.nabble.com/Help-with-SQLite-Query-tp24297858p24305860.html Sent from the SQLite mailing list archive at Nabble.com

[sqlite] Help with SQLite Query

in context: http://www.nabble.com/Help-with-SQLite-Query-tp24297858p24297858.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

Re: [sqlite] Help with SQLite Query

JokBoy andrew.lind...@westnet.com.au wrote: Basically, I would like to be able to query one table based on criteria entered into another table. I have attached an excel file with a couple of hours of monitoring data, the 10 minute data has been interpolated to give minute answers (as MOEData

Re: [sqlite] Help with SQLite Query

Igor, I have tried your query and I don't get any rows returned. Any ideas why it wouldn't work? Regards Andrew -- View this message in context: http://www.nabble.com/Help-with-SQLite-Query-tp24297858p24298529.html Sent from the SQLite mailing list archive at Nabble.com

Re: [sqlite] Help with SQLite Query

JokBoy wrote: I have tried your query and I don't get any rows returned. Any ideas why it wouldn't work? If you tried it against the database file you showed in your original post, note that you have MOEData.Date in different format from Criteria.StartTime_crit and EndTime_crit. Recall that