1 Reply Latest reply on Aug 29, 2012 2:55 PM by Ron M-Oracle

    Ingredient Spec Classification

    RG1000
      In 5.2.2, how do you join the spec classifications to the spec summary tables? I cannot seem to find a relation or join table. I'm looking to join specSummary to specClassificationAttr. I've looked at the database and the schema and don't see how they connect. Thx
        • 1. Re: Ingredient Spec Classification
          Ron M-Oracle
          Here is an example SQL query for an ingredient spec:

          SELECT * FROM IngredientSpec t1
          INNER JOIN specIngredientAttributes t2 ON t1.pkid = t2.Parent
          INNER JOIN IngClassAttrIngAttrJoin t3 ON t2.pkid = t3.fkIngredientAttributes
          INNER JOIN specClassificationAttr t4 ON t3.fkIngClassificationAttr = t4.pkid

          ...