CREATE TABLE Organization_ObjTab OF Organization_Type
 ( Abbrev PRIMARY KEY,
   SCOPE FOR (hasHqIn) 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 hasHqIn =
 ( SELECT REF(cty)
     FROM ORCity cty
     WHERE Name = 'Bruxelles'
       AND Province = 'Bruxelles'
       AND Country = 'B')
WHERE Abbrev = 'EU';
