Re: [sqlite] 2 joins on one table

On 30/09/2014, at 12:04 pm, Paul Sanderson wrote: > I two tables of the form > > create table1 (person1 text, person2 text) > create table2 (person text, picture blob) > > Is it possible to create a join so I can get a resultant dataset of the form > > person1,

[sqlite] 2 joins on one table

I two tables of the form create table1 (person1 text, person2 text) create table2 (person text, picture blob) Is it possible to create a join so I can get a resultant dataset of the form person1, person1picture, person2, person2picture Thanks ___