对于 join, 如果不写 left ,inner ,right ,默认是什么联接呢?
#1. select * from a join b on a.id = b.id#2. select * from a inner join b on a.id = b.id#3. select * from a, b where a.id = b.id上面的三个是相等的.#4.剩下的join类型有:left joinright joincross joinful
转载
2012-02-18 10:43:46 ·
4069 阅读 ·
0 评论