失忆着
2014-07-14 07:31
浏览 643

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

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

相关推荐 更多相似问题