请问oracle高手 SQL语句该如何修改，怎么写。急！！！

后台为ORACEL数据库：

select A.SORDER,A.KOTECD,A.JSTSTM,A.JSTETM,B.WAREHUSFG,B.WAREETM,
from factv2.SAGPLNFL A,FACTV2.SGPROGSS B
Where B.WAREHUSFG=1(1为入库标志)
  AND A.SORDER=B.SORDER
ORDER BY A.SORDER

（说明：SORDER为表单号 KOTECD为工序号 JSTSTM为工序开始时间，JSTETM为工序结束时间。WAREHUSFG入库状态，WAREETM入库时间）

得到以下数据：

SORDER KOTECED JSTSTM JSTETM WAREHUSFG WAREETM
03103410 1015 2008-12-31 13:58:00 2008-12-31 13:58:00 1 2009-01-06 06:15:00
03103410 2015 2008-12-31 13:58:00 2008-12-31 13:58:00 1 2009-01-06 06:15:00
03103410 2025 2008-12-31 18:36:00 2008-12-31 20:40:00 1 2009-01-06 06:15:00
03103410 2026 2008-12-31 20:44:00 2008-12-31 20:45:00 1 2009-01-06 06:15:00
03103410 2030 2008-12-31 23:29:00 2008-12-31 23:29:00 1 2009-01-06 06:15:00
03103410 2036 2009-01-01 05:32:00 2009-01-01 07:23:00 1 2009-01-06 06:15:00
03103410 2040 2009-01-02 15:04:00 2009-01-02 15:04:00 1 2009-01-06 06:15:00
03103410 2054 2009-01-02 23:02:00 2009-01-02 23:02:00 1 2009-01-06 06:15:00
03103410 2070 2009-01-03 04:55:00 2009-01-03 04:55:00 1 2009-01-06 06:15:00
03103410 2075 2009-01-03 05:28:00 2009-01-03 05:28:00 1 2009-01-06 06:15:00
03103410 2080 2009-01-03 15:08:00 2009-01-03 15:08:00 1 2009-01-06 06:15:00
03103410 2090 2009-01-05 05:53:00 2009-01-05 05:53