with this query, besides the fact that is doesnt run. I'm pretty sure I just
have the syntax wrong, but cant find a site with a spec on Access join
syntax.
select
p1.name,
p2.name as father,
p3.name as mother,
p4.name as gfather,
p5.name as gmother
from individuals p1
join individuals p2 on p2.id = p1.father
join individuals p3 on p3.id = p1.mother
join individuals p4 on p4.id = p2.father
join individuals p5 on p5.id = p2.mother
where
p1.id = 0
John Stanley
Web Application Developer
http://www.stangocity.com <http://www.stangocity.com/>
http://www.activeaero.com <http://www.activeaero.com/>
734-547-7277
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
