Hi. I'm trying to INSERT INTO a table using results from a subquery that happens to reference multivalued columns that belong to an association. I keep getting the following error:
"UniVerse/SQL: No 'stored' columns were found defining association" Does anyone know what the problem is? The @ASSOC_KEY.name dictionary is defined in the subquery's file like so: @ASSOC_KEY.testAssoc 0001 PH 0002 key col1 col2 Although col1 & col2 are both i-descriptors. Here's an example of the SQL: INSERT INTO myTable (val1,val2,val3) SELECT col1,col2,col3 FROM table_testAssoc WHERE col2 >= '10-23-10'; Thanks! _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users