左连接:
SELECT * FROM TABLE_A A LEFT JOIN TABLE_B B ON A.KEY=B.KEY
右连接:
SELECT * FROM TABLE_A A RIGHT JOIN TABLE_B B ON A.KEY=B.KEY
内连接:
SELECT * FROM TABLE_A A INNER JOIN TABLE_B B ON A.KEY=B.KEY
左连接:
SELECT * FROM TABLE_A A LEFT JOIN TABLE_B B ON A.KEY=B.KEY
右连接:
SELECT * FROM TABLE_A A RIGHT JOIN TABLE_B B ON A.KEY=B.KEY
内连接:
SELECT * FROM TABLE_A A INNER JOIN TABLE_B B ON A.KEY=B.KEY