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