我试过了,
select b.BORROWER, l.DATEIN, br.BRANCHNAME
from BORROWER b, LOAN l, BRANCH br
where b.cardno=l.cardno
and l.branchid=br.branchid
and b.cardno <'300'
and l.datein <'15-Jan-15'
and (br.BRANCHNAME='California' or br.branchname='Alaska');
但什么也没表现出来。有人能帮忙吗?
select b.BORROWER, l.DATEIN, br.BRANCHNAME
from BORROWER b, LOAN l, BRANCH br
where b.cardno=l.cardno
and l.branchid=br.branchid
and b.cardno <'400'
and l.datein <'2015-01-10'
and (br.BRANCHNAME='California' or br.branchname='Alaska');
但这取决于datein的列类型。是Date
吗?