SQL中,内连接,外连接的书写格式

JOIN 分为内连接,外连接(左外连接,右外连接,全外连接)

内连接: SELECT A.* FROM A INNER JOIN B ON A.ID=B.ID

左外连接: SELECT A.* FROM A LEFT JOIN B ON A.ID = B.ID

右外连接: SELECT A.* FROM A RIGHT JOIN B ON A.ID = B.ID

全外连接: SELECT A.*, B.* FROM A FULL OUTER JOIN B ON A.ID = B.ID

posted @ 2008-06-19 11:13  单车骑客  阅读(1036)  评论(0编辑  收藏  举报