On January 18, 2019 12:54:32 PM EST, Jose Isaias Cabrera <jic...@outlook.com> wrote: > >sqlite> select a.a, a.b, a.c, b.d, b.e as q from a join b on a.a=b.a >where a.a = 1; >sqlite> > >This provides no result. I expected to get, > >1|2|3||
You appear to seek the result of a LEFT JOIN. -- J. King _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users