| re: HELP! Query Ambiguous Outer Joins
Answer is in the message.
Break it down into simple steps
Do step 1 in a query. Then use that query and tblanimal in query 2 to do step 2
and so on
HTH
David B
Lumpierbritches <lumpierbritches@aol.com> wrote in message
news:20040416075317.00710.00000417@mb-m07.aol.com...[color=blue]
> I'm trying to pull all the parents of a particular animal and I have my SQL
> statement that says not supported and when I attempt to run the Query, I get
>
> The SQL statement couldn't be executed because it contains ambiguous outer
> joins. To force one of the joins to perform first, create a separate query[/color]
that[color=blue]
> performs the first join and then include and then include that query in your
> SQL statement.
>
> Here is the Code:
> SELECT tblAnimal.AnimalID, tblAnimal.Sire, tblAnimal.Dam
> FROM tblAnimal AS DamDamDam, ((tblAnimal LEFT JOIN ((((((tblAnimal AS Sire[/color]
LEFT[color=blue]
> JOIN tblAnimal AS SireSire ON Sire.Sire = SireSire.AnimalID) LEFT JOIN
> tblAnimal AS SireDam ON Sire.Dam = SireDam.AnimalID) LEFT JOIN tblAnimal AS
> SireSireSire ON SireSire.Sire = SireSireSire.AnimalID) LEFT JOIN tblAnimal AS
> SireSireDam ON SireSire.Dam = SireSireDam.AnimalID) LEFT JOIN tblAnimal AS
> SireDamSire ON SireDam.Sire = SireDamSire.AnimalID) LEFT JOIN tblAnimal AS
> SireDamDam ON SireDam.Dam = SireDamDam.AnimalID) ON tblAnimal.Sire =
> Sire.AnimalID) LEFT JOIN ((((tblAnimal AS Dam LEFT JOIN tblAnimal AS DamSire[/color]
ON[color=blue]
> Dam.Sire = DamSire.AnimalID) LEFT JOIN tblAnimal AS DamDam ON Dam.Dam =
> DamDam.AnimalID) LEFT JOIN tblAnimal AS DamSireSire ON DamSire.Sire =
> DamSireSire.AnimalID) LEFT JOIN tblAnimal AS DamDamSire ON DamDam.Sire =
> DamDamSire.AnimalID) ON tblAnimal.Dam = Dam.AnimalID) INNER JOIN tblAnimal AS
> DamSireDam ON DamSire.Dam = DamSireDam.AnimalID;
>
> Michael[/color]
| 
