我有一个问题,我很难用laravelEloquent 的ORM编写这个问题.
如果有人能帮忙,我将不胜感激.
下面是SQL表达式:
SELECT DISTINCT cust, cust_no FROM delivery_sap
WHERE cust NOT IN ( SELECT cust_name FROM customer)
AND cust_no NOT IN ( SELECT cust_code FROM customer)
我有一个问题,我很难用laravelEloquent 的ORM编写这个问题.
如果有人能帮忙,我将不胜感激.
下面是SQL表达式:
SELECT DISTINCT cust, cust_no FROM delivery_sap
WHERE cust NOT IN ( SELECT cust_name FROM customer)
AND cust_no NOT IN ( SELECT cust_code FROM customer)
我将下面的代码pull('cust')改为pull('cust_name'),然后
DB::table('delivery_sap')
->whereNotIn('cust', DB::table('customer')->pluck('cust_name'))
->whereNotIn('cust_no', DB::table('customer')->pluck('cust_code'))
->select('cust', 'cust_no')
->groupBy('cust', 'cust_no')
->get();