SELECT queries that access both Vector and traditional Ingres tables cannot execute. To cross join data in traditional Ingres and Vector you have to move the data either into traditional Ingres or into Vector using INSERT…SELECT or CREATE TABLE AS SELECT.