What do you suggest should be the full SQL then? RBS
On Wed, Nov 17, 2010 at 8:16 AM, luuk34 <luu...@gmail.com> wrote: > On 17-11-10 00:17, Petite Abeille wrote: >> select t1.patient_id >> from table1 t1 >> join ( >> select table1.address, >> min( table1.date_of_birth ) as date_of_birth >> from table1 >> group by table1.address >> ) >> as t2 >> join t2.address = t1.address > > 'join' should be: > > ON t2.address = t1.address > > >> and t2.date_of_birth = t1.date_of_birth > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users