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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
