.内连接:利用内连接可获取两表的公共部分的记录
语句如下:Select * from A JOIN B ON A.Aid=B.Bid;
.外连接:外连接分为两种,一种是左连接(Left JOIN)和右连接(Right JOIN)
语句如下:Select * from A JOIN B ON A.Aid=B.Bid;
.外连接:外连接分为两种,一种是左连接(Left JOIN)和右连接(Right JOIN)