1、SQL LIKE 忽略大小写的方式
select * from TableA a where UPPER(a.name) like '%MAIL%'
2、Table Inner Join的使用
select a.name,b.name where TableA a join TableB b on a.condition = b.condition where a.filter = 'aFilter' and b.filter = 'bFilter'
内联是交集,外联是并集,左外联左全集