Darn ti!  Thanks.

On Saturday, January 19, 2019 07:20 AM, J. King wrote,
>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.

Yep, that's it. Thanks.

josé
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to