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. ___

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

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: > 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 Tab in the excel sheet)