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". --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users