ORA-00933: SQL command not properly ended 为何会报错误,求大神解答
小庆宝宝 2016-06-17 02:25:04 SELECT
to_char( (s1.in_process_time -TO_DSINTERVAL( '0 8:00:00' ) ),'YYYY-MM-DD') as "测试日期",
(k1.PM - k2.PM) as "功率差"
FROM SAJET.G_SN_RULE_STATUS s1
SAJET.G_SN_RULE_STATUS k0
(select s1.serial_number,s1.PM FROM s1 LEFT JOIN k0 ON k0.serial_number = s1.serial_number AND s1.PROCESS_ID = k0.process_id
AND s1.in_process_time < K0.IN_PROCESS_TIME where s1.PROCESS_ID=100028) k1
LEFT JOIN (select s1.serial_number,s1.PM FROM s1 LEFT JOIN k0 ON k0.serial_number = s1.serial_number AND s1.PROCESS_ID = k0.process_id
AND s1.in_process_time < K0.IN_PROCESS_TIME where s1.PROCESS_ID=100018) k2
ON k1.serial_number = k2.serial_number
WHERE
K0.SERIAL_NUMBER IS NULL
AND to_char(s1.in_process_time -TO_DSINTERVAL( '0 8:00:00' ) ,'YYYY-MM-DD')>=to_char( current_date-TO_DSINTERVAL( '31 00:00:00'),'YYYY-MM-DD')
AND to_date(s1.in_process_time -TO_DSINTERVAL( '0 8:00:00' ) ,'YYYY-MM-DD')!=to_date( current_date,'YYYY-MM-DD')
group by to_char( (s1.in_process_time -TO_DSINTERVAL( '0 8:00:00' ) ),'YYYY-MM-DD')
order by to_char( (s1.in_process_time -TO_DSINTERVAL( '0 8:00:00' ) ),'YYYY-MM-DD')