[sqlite] implicit vs explicit joins

2015-06-11 Thread R.Smith
On 2015-06-11 01:36 PM, Igor Korot wrote: > Clemens, > > On Thu, Jun 11, 2015 at 7:01 AM, Clemens Ladisch > 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.ROW

[sqlite] implicit vs explicit joins

2015-06-11 Thread Paul Sanderson
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:

[sqlite] implicit vs explicit joins

2015-06-11 Thread 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_

[sqlite] implicit vs explicit joins

2015-06-11 Thread Paul Sanderson
I have just been asked whether implicit and explicit join are the same and was given an example There queries below produce the same results but explain indicates that they are different. My question though is in what instances are the actual results of such a query likely to be different and is

[sqlite] implicit vs explicit joins

2015-06-11 Thread Hick Gunter
5 12:46 An: General Discussion of SQLite Database Betreff: [sqlite] implicit vs explicit joins I have just been asked whether implicit and explicit join are the same and was given an example There queries below produce the same results but explain indicates that they are different. My question th

[sqlite] implicit vs explicit joins

2015-06-11 Thread Igor Korot
Clemens, On Thu, Jun 11, 2015 at 7:01 AM, Clemens Ladisch 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 me

[sqlite] implicit vs explicit joins

2015-06-11 Thread Keith Medcalf
l Discussion of SQLite Database > Subject: [sqlite] implicit vs explicit joins > > I have just been asked whether implicit and explicit join are the same > and was given an example > > There queries below produce the same results but explain indicates > that they are different