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 be because there's only one pair of records (one from
errorapi and the other from login) that satisfies the condition. Check
your data; in particular, verify that login.ende is populated correctly.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
