摘要： id name id name 1 zhangsan 1 hanmeimei 2 lisi 2 wangwu 3 wangwu join:select * from A join B on A.name=B.name 取交集 id name id name 1 wangwu 2 wangwu ful 阅读全文