2 u010260910 u010260910 于 2014.07.14 15:31 提问

有关于Oracle子查询问题

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表中的数据

Csdn user default icon
上传中...
上传图片
插入图片