求个查询语句

[-一个大坑]

select a.deriveno, a.carno, to_char(a.actualtime,'yyyy-mm-dd hh24:mi:ss') as 开始时间,
select a.deriveno,
       a.carno,
       to_char(a.actualtime, 'yyyy-mm-dd hh24:mi:ss') as 开始时间,
       to_char(a.actualtime, 'yyyy-mm-dd hh24:mi:ss') as 结束时间
  from app_carstatus a, app_send b
 where a.deriveno = b.deriveno
   and b.status in ('0', '10')
   and b.deriveno not in (select deriveno from app_ridecost)

a.stagecode = '3' 时a.actualtime为开始时间，a.stagecode = '4' 时a.actualtime为结束时间
a.stagecode = '6' 时a.actualtime为开始时间，a.stagecode = '7' 时a.actualtime为结束时间（单程a.stagecode没有6.7，双程才有）

[卖水果的net]

源数据长什么样，结果又是什么 样的，贴一下测试 数据；

[-一个大坑]

 SELECT T1.DERIVENO, T1.CARNO, T1.RIDE_STARTTIME, T2.COMPLETEDT
   FROM (SELECT DERIVENO, CARNO, actualtime RIDE_STARTTIME
           FROM (select a.deriveno,
                        a.carno,
                        a.stagecode,
                        to_char(a.actualtime, 'yyyy-mm-dd hh24:mi:ss') as actualtime
                   from app_carstatus a, app_send b
                  where a.deriveno = b.deriveno
                    and b.status in ('0', '10')
                    and b.deriveno not in (select deriveno from app_ridecost))
          WHERE STAGECODE in ('3','6')) T1
   LEFT JOIN (SELECT DERIVENO, COMPLETEDT
                FROM (select a.deriveno,
                        a.carno,
                        a.stagecode,
                        to_char(a.actualtime, 'yyyy-mm-dd hh24:mi:ss') as COMPLETEDT
                   from app_carstatus a, app_send b
                  where a.deriveno = b.deriveno
                    and b.status in ('0', '10')
                    and b.deriveno not in (select deriveno from app_ridecost))
               WHERE STAGECODE in ('4','7')) T2
     ON T1.DERIVENO = T2.DERIVENO

以前问过类似的，我在那个上面改了下。是不是

[-一个大坑]

引用 2 楼 wmxcn2000 的回复:

源数据长什么样，结果又是什么 样的，贴一下测试 数据；

这是数据，我怕写in会导致3.4和5.6两条数据，但是in能查出3或4条数据出来