mysql - 如何在MYSQL中找到加州和阿拉斯加日期在10年1月15日之前且卡号小于400的所有贷款借款人？

Question

我试过这个，

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');

但什么也没显示。有人可以帮忙吗？

Answer 1

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的列类型。是日期吗？