在框架中使用代码如下:
~~~
$order = M("order_zc_xxx") ; //当前数据库下的表
$field[] = "order_zc_xxx.*";
$field[] = "sgoods.name";
$row = $order->JOIN("left join 库名.表名 as sgoods on sgoods.id = order_zc_xxx.goods_id")->where("ordermainid = {$id}")->field($field)->select();
$list['list'] = $row;
success('获取成功',$list);
~~~
在sql语句使用代码如下:
~~~
SELECT gb.id,gb.name,gb.logo,gb.mark FROM 库名.表名 cg
LEFT JOIN 库名.表名 gb on gb.id=cg.brand_id
WHERE cg.tag_type=1 GROUP BY gb.name limit 0,{$pagesize}
~~~
如果是添加和编辑以及删除 都是差不多的语法的