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