多表查询 交叉连接(笛卡尔积) select * from A,B内连接 隐式内连接:select * from A,B where b.aid = a.id 过滤掉交叉连接中无意义的数据 显式内连接:select * from A inner join B on b.aid = a.id外连接 左外连接:select * from A left [outer] join B on b.aid = a.id 右外连接:select * from A right [outer] join B on b.aid = a.id