Re: Questions?

Gerardo Garc'a wrote: > 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 update table set field1= (select field1 from table1 where table.field1=table1.field1) > > 2: > Its posible to have the next results > > Select sum(Units) as Unit from SevenmillonRecordTable Just leave out the 'as', and you've got it. examples should be in the manuals. Hope this helps, Douglas Wilson