Questions?

We are testing Informix & Metacube on NT and Unix We have knowlegde of Microsoft SQL Server and we have some questions 1: How I can update/delete one table from a resulta of a subquery or a view Example Update Table Set field1 = Table1.field1 From Table, Table1 Where Table.filed1 = Table1.field1 2: Its posible to have the next results Select sum(Units) as Unit from SevenmillonRecordTable MS SQL Server INFORMIX 7.22 INFORMIX 7.23 Alpha 4100 Alpha 4100 Intel 4/200 768 MB RAM 1GB RAM 768 MB RAM 10 secs 3.5 min 4 min