Tried your SQL, but it doesn't run. Will fiddle it and see if I can make it work.
RBS On Wed, Nov 17, 2010 at 9:00 AM, luuk34 <luu...@gmail.com> wrote: > On 17-11-10 09:58, Bart Smissaert wrote: >> What do you suggest should be the full SQL then? >> > 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 > 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