SQLite Forum

Can this SQL be simplified?
Login
It's a clean query but has the disadvantage of scan all rows of T2.