select *
from (select rownum as rowsize,
d.route_name as route_name,
d.depart_count as depart_count,
d.createby_name as createby_name,
to_char(d.createby_date, 'yyyy-MM-dd') as createby_date,
d.remark as remark
from base_detail d
where 1 = 1
and d.detail_id in
(select l.line_id
from base_line l)
如何取得l表中的数据