[VSDK Macho] Wishes and performance stuff

[Totte Alm]

Hello Frank and Ruslan,

tisdagen den 21 januari 2003 kl 15.09 skrev Frank Schima:

> Let's take the 2nd case above because it is more complex. Note that I  
> use a FROM clause
> to specify an alias for the HolderTable because that is the only place  
> that is normally
> allowed to be specified.
>
> UPDATE HolderTable
> SET    H.Totalshares=
>         (SELECT SUM(S.shares) FROM ShareRecord S WHERE  
> S.parentHolder=H.recid)
> FROM   HolderTable H
> WHERE  H.BuyBack=0

This was what I first tried but remebered that Valentina doesnt do  
subselects either.

I agree that this is a better syntax to be SQL92 compliant (or whatever  
the current std is set to).

// Totte

>
------------------------------------------------------------------------ 
---------------------
Intelligence is meassured in tary; decitary, centitary and military.