Angel, thanks. I was avoiding that Query builder for some reason, and it
turns out to be pretty easy to use. So anyway, I got it working.
-----Original Message-----
From: Angel Stewart [mailto:[EMAIL PROTECTED]
Sent: Friday, September 03, 2004 2:14 PM
To: CF-Community
Subject: RE: Rusty on Access syntax
Use Access Query Builder to create the query and then go to the SQL
View.
-Gel
-----Original Message-----
From: John Stanley [mailto:[EMAIL PROTECTED]
Okay, I have to do some work in Access and I cant figuire out the
problem
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
_____
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- Rusty on Access syntax John Stanley
- RE: Rusty on Access syntax Angel Stewart
- RE: Rusty on Access syntax John Stanley
- RE: Rusty on Access syntax Angel Stewart