1. 查询本月交易金额最高的卡号
select DISTINCT cardID from transinfo where transMoney=(select ... from ...)
2.查询挂失账号的客户信息
使用子查询N或内连接查询INNER join
select ... from userinfo where customerID IN(select ... from ...)
3.催款提醒业务
使用子查询IN或内连接查询 INNER JOIN
select ... from userinfo INNER JOIN ...