摘要: 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 ... 阅读全文
posted @ 2008-06-19 11:13 单车骑客 阅读(1048) 评论(0) 推荐(0)