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')) NOT
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 b
2 matches
Mail list logo