- 子查询:
select * from a where id in (select aId from b where name="zhangsan")
- all/any/exist/in
- 多表查:
select * from a,b where a.id=b.aId
- 连表查:
select * from a inner join b on a.id=b.aId
- 内连接:交集
- 左连接:左表+交集
- 右连接:右表+交集
select * from a where id in (select aId from b where name="zhangsan")
select * from a,b where a.id=b.aId
select * from a inner join b on a.id=b.aId