SQL模糊查询，联表查询JoinON

-- 模糊查询
-- like结合 %(代表0到任意个字符) _(代表一个字符)
select [] from [] where xxx like '刘%'

-- in
select [] from [] where xxx in (a, b, c);

-- join
-- join on 连接查询
-- where 等值查询
select A.a, b, c, d
from xxx as A
inner join yyy as B
on A.a = B.a