$info=$sellHouse->alias('H')->join('left join cms_archives_3 as HD on HD.aid=H.aid')->order($sort.' '.$order)->page($page.','.$rows)->field('H.aid,H.subject,H.lpmc,HD.content,HD.lxdh')->where($map)->page($page,$rows)->select(); 最佳答案
$info=$sellHouse->alias('H')->join('left join cms_archives_3 as HD on HD.aid=H.aid')->order($sort.' '.$order)->page($page.','.$rows)->field('H.aid,H.subject,H.lpmc,HD.content,HD.lxdh')->where($map)->page($page,$rows)->select();