SQL问题 在线等
街角嘚堕落 2012-06-20 10:21:28 sum(SELECT DAILY_FIXED_COSTS FROM OTHER_EXPENSES WHERE BS.BOOKING_SHEET_DATE BETWEEN VALID_START_TIME AND VALID_END_TIME)/
(ISNULL(select top 1 truck_number from TRUCK_DRIVER_NUMBER WHERE VALID_START_TIME<BS.BOOKING_SHEET_DATE,1)*ISNULL(BS.DAY_NUMBER,0))
这句报','和'/'有语法错误
SUM(SELECT ISNULL((SELECT TOP 1 BASIC_WAGE FROM DRIVER_BASIC_WAGE DBW WHERE DBW.START_VALID_TIME<BS.BOOKING_SHEET_DATE
AND BDS.DRIVER_ID=DBW.DRIVER_ID ORDER BY START_VALID_TIME )/30,0) FROM BOOKING_SHEET_drivers BDS
WHERE BS.ID=BDS.BOOKING_SHEET_ID)*ISNULL(BS.DAY_NUMBER,0)
这句报‘*’附件有语法错误 怎么回事啊?