分类：laravel联查

2021
03-19

laravel join关联查询代码实例

laraveljoin关联查询1、两表关联$fbaInventoryTb=(new\App\Model\Amz\Fba\InventoryReport)->getTable();$productTb=(new\App\Model\Amz\Product)->getTable();$twInventoryTb=(new\App\Model\TWUsa\TwusaInventory)->getTable();$qry=\DB::table($fbaInventoryTb);$qry->select($fbaInventoryTb.'.*')->where($fbaInventoryTb.'.ec_id',1)->leftjoin($productTb,$productTb.'.sku','=',$fbaInventoryTb.'.... 继续阅读 >