2012年4月13日
mysql left join ,right join ,inner join
摘要： 表A lefttable,表B righttableleft join: 与right join 相类似，反之亦然。1. select lefttable.*,righttable.* from lefttable left join righttable on lefttable.id = righttable.id and righttable.name = "xxx" where lefttable.name = "XXX";2. select lefttable.*,righttable.* from lefttableleft joinrigh 阅读全文
posted @ 2012-04-13 18:07 雪刚 阅读(304) 评论(0) 推荐(0)