17,086
社区成员
发帖
与我相关
我的任务
分享
--试试这样
select count(*)
from lend_hist lh,indi_acct ia
where ia.prop_no=lh.prop_no_f
and lh.call_no like 'T%'
and ia.call_no like 'T%'
and lh.lend_date between '2008-01-01' and '2011-01-01'
and ia.in_date between '2008-01-01' and '2011-01-01'