select ve.*,vd.*,vq.*
from vender_enquiry_detail vd
join vender_quotation_detail vq
on vd.enq_no = vq.enq_no
and vd.pn = vq.pn
join vender_enquiry ve
on vd.enq_no = ve.enq_no
where to_char(ve.created_date,'yyyy-mm-dd') >= '2010-12-01'
and to_char(ve.created_date,'yyyy-mm-dd') <= '2010-12-14'
oracle 用to_char()日期区间比较
最新推荐文章于 2021-06-02 19:52:34 发布