多表查询怎么写
$data = GoodsModel::alias('a')->join('__SHOP_GOODS_CLASS__ b','a.gc_id = b.id')->select();
这样写会报错Column not found: 1054 Unknown column 'a.gc_id' in 'on clause'
这样写会报错Column not found: 1054 Unknown column 'a.gc_id' in 'on clause'
没有找到相关结果
已邀请:
1 个回复
dolphinphp
赞同来自:
$data = GoodsModel::view('shop_goods', true)->view('shop_goods_class', true, 'shop_goods_class.id=shop_goods.gc_id')->select();参考 https://www.kancloud.cn/manual/thinkphp5/156576