http://jgofri.livejournal.com/ ([identity profile] jgofri.livejournal.com) wrote in [personal profile] 3eta 2012-09-29 11:06 pm (UTC)

I may be rusty on the syntax, but I think something like this will work:

select t1.last_name, t1.first name, t1.dob "son dob", t2.dob "dad dob"
from Table t1, Table t2
where t1.father_person_id = t2.person_id
and t1.first_name = t2.first_name

Post a comment in response:

This account has disabled anonymous posting.
If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting