thinkphp 3.2 join

最新推荐文章于 2024-10-06 08:55:12 发布

weixin_30376163

最新推荐文章于 2024-10-06 08:55:12 发布

阅读量75

点赞数

文章标签： php

原文链接：http://www.cnblogs.com/wesky/p/5837740.html

版权

$res2 = M('stat_info a')
->join(C('DB_PREFIX').'stock b ON a.goods_id = b.goods_id')
->field('a.*,b.goods_sn,b.goods_name,b.goods_barcode')
->select();


$res2 = M('stat_info a')
->join(__STOCK__.' b ON a.goods_id = b.goods_id')
->field('a.*,b.goods_sn,b.goods_name,b.goods_barcode')
->select();

$res = M('stat_info a')
->join('__STOCK__ b ON a.goods_id = b.goods_id')
->field('a.*,b.goods_sn,b.goods_name,b.goods_barcode')
->where('a.stat_id='.$id)
->select();

两种方法都可以

$res = M('stat_info a')
->join('__STOCK__ b ON a.goods_id = b.goods_id')
->join('__DEPOT__ C ON b.depot_id = c.id')
->field('a.*,b.goods_sn,b.goods_name,b.goods_barcode,c.depot_name')
->where('a.stat_id='.$id)
->select();