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
>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,
>>
On January 18, 2019 12:54:32 PM EST, Jose Isaias Cabrera
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
Greetings!
Imagine this scenario,
create table a (a, b, c);
create table b (a, d, e);
insert into a values (1, 2, 3);
insert into a values (2, 3, 4);
insert into a values (3, 4, 5);
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> select a.a, a.b, a.c, b.d,
3 matches
Mail list logo