HELP! Query Ambiguous Outer Joins

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Lumpierbritches
    #1

    HELP! Query Ambiguous Outer Joins

    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 that
    performs the first join and then include and then include that query in your
    SQL statement.

    Here is the Code:
    SELECT tblAnimal.Anima lID, tblAnimal.Sire, tblAnimal.Dam
    FROM tblAnimal AS DamDamDam, ((tblAnimal LEFT JOIN ((((((tblAnimal AS Sire LEFT
    JOIN tblAnimal AS SireSire ON Sire.Sire = SireSire.Animal ID) LEFT JOIN
    tblAnimal AS SireDam ON Sire.Dam = SireDam.AnimalI D) LEFT JOIN tblAnimal AS
    SireSireSire ON SireSire.Sire = SireSireSire.An imalID) LEFT JOIN tblAnimal AS
    SireSireDam ON SireSire.Dam = SireSireDam.Ani malID) LEFT JOIN tblAnimal AS
    SireDamSire ON SireDam.Sire = SireDamSire.Ani malID) LEFT JOIN tblAnimal AS
    SireDamDam ON SireDam.Dam = SireDamDam.Anim alID) ON tblAnimal.Sire =
    Sire.AnimalID) LEFT JOIN ((((tblAnimal AS Dam LEFT JOIN tblAnimal AS DamSire ON
    Dam.Sire = DamSire.AnimalI D) LEFT JOIN tblAnimal AS DamDam ON Dam.Dam =
    DamDam.AnimalID ) LEFT JOIN tblAnimal AS DamSireSire ON DamSire.Sire =
    DamSireSire.Ani malID) LEFT JOIN tblAnimal AS DamDamSire ON DamDam.Sire =
    DamDamSire.Anim alID) ON tblAnimal.Dam = Dam.AnimalID) INNER JOIN tblAnimal AS
    DamSireDam ON DamSire.Dam = DamSireDam.Anim alID;

    Michael
    Tags: None
    • David B
      #2
      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 <lumpierbritche s@aol.com> wrote in message
      news:2004041607 5317.00710.0000 0417@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.Anima lID, 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.Animal ID) LEFT JOIN
      > tblAnimal AS SireDam ON Sire.Dam = SireDam.AnimalI D) LEFT JOIN tblAnimal AS
      > SireSireSire ON SireSire.Sire = SireSireSire.An imalID) LEFT JOIN tblAnimal AS
      > SireSireDam ON SireSire.Dam = SireSireDam.Ani malID) LEFT JOIN tblAnimal AS
      > SireDamSire ON SireDam.Sire = SireDamSire.Ani malID) LEFT JOIN tblAnimal AS
      > SireDamDam ON SireDam.Dam = SireDamDam.Anim alID) ON tblAnimal.Sire =
      > Sire.AnimalID) LEFT JOIN ((((tblAnimal AS Dam LEFT JOIN tblAnimal AS DamSire[/color]
      ON[color=blue]
      > Dam.Sire = DamSire.AnimalI D) LEFT JOIN tblAnimal AS DamDam ON Dam.Dam =
      > DamDam.AnimalID ) LEFT JOIN tblAnimal AS DamSireSire ON DamSire.Sire =
      > DamSireSire.Ani malID) LEFT JOIN tblAnimal AS DamDamSire ON DamDam.Sire =
      > DamDamSire.Anim alID) ON tblAnimal.Dam = Dam.AnimalID) INNER JOIN tblAnimal AS
      > DamSireDam ON DamSire.Dam = DamSireDam.Anim alID;
      >
      > Michael[/color]

        Comment

        Previous template Next
        Working...