Two ways Dynamic Normalization
SELECT colname1,colname2,colname3 FROM tablename_assocname; Using this method only the primary key (@ID) and columns named in the association can be selected. UNNEST Operator SELECT colname1,colname2,colname3 FROM UNNEST tablename ON assocname; Using this method (which is akin to BY.EXP in "the other" query language TCL) you can select any columns whether from the base table (in which case they'll be repeated) or from the assocation. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
