CREATE TABLE Organization_ObjTab OF Organization_Type
 ( Abbrev PRIMARY KEY,
   SCOPE FOR (has_hq_in) IS ORCity )
   NESTED TABLE Members STORE AS Members_nested;
INSERT INTO Organization_ObjTab VALUES
 ( Organization_Type('European Community', 'EU',
                      Member_List_Type(), NULL, NULL));
UPDATE Organization_ObjTab
SET has_hq_in =
 ( SELECT REF(cty)
     FROM ORCity cty
     WHERE Name = 'Brussels'
       AND Province = 'Brabant'
       AND Country = 'B')
WHERE Abbrev = 'EU';
