James K. Lowden, on Tuesday, February 12, 2019 11:39 AM, wrote... >On Tue, 12 Feb 2019 15:05:29 +0000 >Jose Isaias Cabrera <jic...@outlook.com> wrote: > >> >SELECT * From t WHERE datestamp = "20190208" >> >> Ok, Simon, I'll bite; :-) Imagine this table: >> >> t (n INTEGER PRIMARY KEY, a, b, c, d, e, idate) > >That's better. > >> how would I find the differences in the fields based on the different >> idate? > >select ... >from t as now join t as then >on now.idate = '20190208' >and then.idate = '20190207' -- note single quotes >and ... -- other things that match >where ... --- things that don't match > >Can't be more specific than that when the question is "find the >differences".
No, this is great. This is great, thanks. josé _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
