在查询之前首先实例化一个模型
$list = M('list'); // 表前缀是 tp_
一、sql语句查询
$sql = 'select * from tp_list as list, tp_article as article where list.sub_category = article.sub_category';
print_r($list->query($sql));
二、join方法查询
$listArticle = $list->join('__ARTICLE__ ON __LIST__.sub_category = __ARTICLE__.sub_category')->select(); // __ARTICLE__ = tp_article
print_r($listArticle);
三、table方法查询
$listArticle = $list->table('tp_list as list, tp_article as article')->where('list.sub_category = article.sub_category')->select();
print_r($listArticle);
欢迎关注技术开发分享录:http://fenxianglu.cn/