under 6.5.3 I see that I cannot do Views on Unions. Is this still true? This seems odd since a UNION should be a an R_Table.... Also it seems that I could not do a SELECT INTO or CREATE TABLE AS with a union (I get an error at union). Is there a syntax (i.e. using ()'s) that will work? -- Zot O'Connor http://www.ZotConsulting.com http://www.WhiteKnightHackers.com