On Wed, Feb 27, 2019 at 2:18 PM Jose Isaias Cabrera <jic...@outlook.com> wrote:
> Thanks. This is exactly what I needed. So, there is really no JOIN here, > or is the "from t outer_t, z outer_z" a JOIN like statement? Where can I > read more about this? And yes, your assessment of t(a, idate) and z(f, > idate) being unique are true. > Yes there is: select ... > from t outer_t, z outer_z > where a == f > and a == 'p001' > and ... > That's equivalent to select ... from t outer_t join z outer_z on t.a = z.f With additional where clauses involving correlated subqueries to determine the max(idate) on both sides, given a given a value (and thus f value too, given the join condition). At least that's how I read it. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users