Thank You Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence
On 11 June 2015 at 12:01, Clemens Ladisch <clemens at ladisch.de> wrote: > 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
