Database

Jörgen Andersson wrote:

Did you just recommend the use of a trigger

CREATE TABLE statuser
	([userid] int)
;
	
INSERT INTO statuser
	([userid])
VALUES
	(1),
	(2)
;

CREATE TABLE stat
	([userid] int, [status] int, [startdate] date)
;
	
INSERT INTO stat
	([userid], [status], [startdate])
VALUES
	(1, 1, '2012-05-30'),
	(1, 2, '2013-06-23')
;
with maxstat as (
    select  s.userid,max(startdate) startdate
    from    statuser su
    left outer join stat s
        on  su.userid = s.userid
    group by s.userid
    )
select  s.userid,s.status,s.startdate
from    maxstat m
join stat s
    on  m.userid = s.userid
    and m.startdate = s.startdate

Kornfeld Eliyahu Peter wrote:

trigger fires trigger that fires trigger...and so on.

Mycroft Holmes wrote:

You should be storing the data as a datetime TYPE not a string

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

SQLite does not have a DATETIME datatype