====== 5.4 Aggregate ======
[[dido:public:s_cli:05_contents:01_prt:04_dll:start| Return to DidoDLL]]

An Aggregate is when a new [[dido:public:ra:xapend:xapend.a_glossary:s:smart_contract|Smart Contract]] is created from a collection of other Smart Contracts and the originally Smart Contracts no longer exist as entities. For example, a can of soup is an aggregate of a can, tomatoes, salt, and other sices. Each of the original objects contained within a Smart Contract are not part of the can of soup. 

<code sql>
CREATE  AGGREGATE CanOfSoup
      FROM  Tomatoes,
            Salt,
            Spice,
            Water,
            Onion,
            Butter,
            Oregano,
            Broth
     WHERE  Tomatoes.id = '$1' and
            Salt.id = '$2' and
            Spice.id = '$3' and
            Water.id = '$4' and
            Onion.id = '$5' and
            Butter.id = '$6' and
            Oregano.id = '$7' and
            Broth.id = '$8'
     RECORD {"Tomatoes", Tomatoes.id} and
            {"Salt", Salt.id} and
            {"Spice", Spice.id} and
            {"Water", Water.id} and
            {"Onion", Onion.id} and
            {"Butter", Butter.id} and
            {"Oregano", Oregano.id} and
            {"Broth", Broth.id}
            AS parents,     
            "Canning Factory Q, Assembly Line 1" AS process;   
</code>


/**=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
/* To add a discussion page to this page, comment out the line that says 
  ~~DISCUSSION:off~~
*/
~~DISCUSSION:on|Outstanding Issues~~
~~DISCUSSION:off~~