1 Reply Latest reply: Aug 29, 2012 9:55 AM by Ron M-Oracle RSS

    Ingredient Spec Classification

    RMG123
      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

          ...