[sqlite] implicit vs explicit joins

[Clemens Ladisch]

Paul Sanderson wrote:
> I have just been asked whether implicit and explicit join are the same
>
> select text, handle.id from message,handle  where handle_id = handle.ROWID;

This is an implicit *inner* join.

> SELECT message."text",  handle.id FROM message  LEFT JOIN handle ON 
> message.handle_id = handle."ROWID";

This is an explicit *outer* join.

Outer joins are one reason for using explicit joins, but you want to
compare against a query with the same semantics:

  select text, handle.id from message join handle on handle_id = handle.ROWID;


Regards,
Clemens