贷款期限>15年,抵押类型='3',3(万)<抵押金额<7(万))要同一笔贷款的吗?如果是,如下
select *
from 表1,表k1,表k2,表k3,表k4,表k5,表loan,
(select 客户id,sum(loansum) loansum from 表loan) sumloan
where 表1.客户id = 表k1.客户id
and 表1.客户id = 表k2.客户id
and 表1.客户id = 表k3.客户id
and 表1.客户id = 表k4.客户id
and 表1.客户id = 表k5.客户id
and 表1.客户id = 表loan.客户id
and 表1.客户id = sumloan.客户id
and 表1.客户类型='2'
and 表1.name like '%股份公司%'
and 表k1.房价 > 30 //万
and 表k2.工作年限 > 4 //年
and sumloan.loansum > 20
and sumloan.loansum < 40
and 表loan.year > 15 //年
and 表loan.type = '3'
and 表loan.pSum > 3 //万
and 表loan.pSum < 7 //万
select *
from 表1,表k1,表k2,表k3,表k4,表k5,表loan,
(select 客户id,sum(loansum) loansum from 表loan) sumloan
where 表1.客户id = 表k1.客户id
and 表1.客户id = 表k2.客户id
and 表1.客户id = 表k3.客户id
and 表1.客户id = 表k4.客户id
and 表1.客户id = 表k5.客户id
and 表1.客户id = 表loan.客户id
and 表1.客户id = sumloan.客户id
and 表1.客户类型='2'
and 表1.name like '%股份公司%'
and 表k1.房价 > 30 //万
and 表k2.工作年限 > 4 //年
and sumloan.loansum > 20
and sumloan.loansum < 40
and 表loan.year > 15 //年
and 表loan.type = '3'
and 表loan.pSum > 3 //万
and 表loan.pSum < 7 //万
from customer,k1,k2
where customer.id=k1.id
and k1.id=k2.id
and customer.name like "股份公司"
and customer.kind='2'
and k1.price>30
and k2.year>4
and customer.id in (
select id
from (select id,sum(nvl(loanSum,0)) Tot_Loan from loan where year>15 group by id)
where 40>Tot_Loan and Tot_loan>20;
INTERSECT
select id
from pledge
where type='3' and psum>3 and pSum<7
);