| Subject | SQL ANSI 92 Syntax | 
|---|---|
| Author | Cipto | 
| Post date | 2007-02-20T04:11:57Z | 
Hi,
I have a query like this:
UPDATE Ulsal
SET SalIncidental =
(select sum((i.CvaIncToel * 100)/ i.CvaPart) /sum(i.CvaNumber)
from Inccva i
where SalScale=i.CvaScale
and SalSort=i.CvaSort
and SalPeriod=i.CvaPeriod
);
I know that this query is work on FB but, I'm curious whether this syntax is
ANSI 92 standart or not. Can anyone help me?
TIA
            I have a query like this:
UPDATE Ulsal
SET SalIncidental =
(select sum((i.CvaIncToel * 100)/ i.CvaPart) /sum(i.CvaNumber)
from Inccva i
where SalScale=i.CvaScale
and SalSort=i.CvaSort
and SalPeriod=i.CvaPeriod
);
I know that this query is work on FB but, I'm curious whether this syntax is
ANSI 92 standart or not. Can anyone help me?
TIA