Re: [sqlite] qualified join

I had a similar problem recently, the way I solved it looks like that (it might not be pretty, but it works) SELECT t1.name, t2.deleted FROM t2 INNER JOIN ( SELECT t2.id, MAX(t2.time) AS last_time FROM t2 GROUP BY t2.id ) AS t3 ON t2.id =

[sqlite] qualified join

I have the following two table defs: CREATE TABLE t1(id INTEGER PRIMARY KEY,name VARCHAR(64)); CREATE TABLE t2(id INTEGER,time INTEGER,deleted INTEGER(1) PRIMARY KEY(id,time)); My question is, how can I: "select t1.name,t2.deleted from t1 join t2 using id" but only keep each row where t2.time