Re: [sqlite] JOIN on between

On 1/11/2012 3:49 PM, Pawl wrote: select errorapi.*,login.* from errorapi JOIN login on (errorapi.start between login.start and login.ende) This command show only one end record. It is possible to use JOINS? I don't see anything wrong with the query. If it only reports one record, that must

[sqlite] JOIN on between

Hi, I need to join two table according to range of date. Fist table is error log table second is users{operators} login. I need to show complete table with all error with actual user id. CREATE TABLE [login] ( [id] iNTEGER NOT NULL, [start] TIMESTAMP DEFAULT (datetime('now','localtime'))