select* from AA INNER JOIN BB ON AA.A_ID=BB.B_ID (公共部分)
select* from AA LEFT JOIN BB ON AA.A_ID=BB.B_ID (左连接, A为基础)
select* from AA RIGHT JOIN BB ON AA.A_ID=BB.B_ID(右连接,B为基础)
select* from BB full JOIN AA ON AA.A_ID=BB.B_ID (全连结)
select* from AA INNER JOIN BB ON AA.A_ID=BB.B_ID (公共部分)
select* from AA LEFT JOIN BB ON AA.A_ID=BB.B_ID (左连接, A为基础)
select* from AA RIGHT JOIN BB ON AA.A_ID=BB.B_ID(右连接,B为基础)
select* from BB full JOIN AA ON AA.A_ID=BB.B_ID (全连结)