|
Тема |
Нищо, че става дума ЗА ЦЕЛИ ЧИСЛА [re: k] |
|
Автор |
NDeu (член) |
|
Публикувано | 04.06.03 14:39 |
|
|
вземи пробвай :
SELECT 110*cast(SUM(T_Work.WDays) as integer)/T_MonthDays.MDWorkDays AS A3 FROM T_Work,T_Employed_Ch,T_Employed,T_MonthDays WHERE T_Work.CRid=T_Employed.CRid AND T_Employed_Ch.URid=T_Employed.URid AND T_Employed_Ch.UURid=T_Work.UURid AND T_MonthDays.MDMonth=T_Work.WMonth AND T_Work.CRid=2 AND T_Work.WMonth='2003-04-01' AND T_Work.WPayMonth<='2003-05-01' AND T_Employed.URid=2 GROUP BY T_Employed.URid;
|
| |
|
|
|