Laravel Eloquent在子查询中带有两个"WHERE NOT IN" [英] Laravel Eloquent with two “WHERE NOT IN” in subquery

问题描述

我有这个查询，无法在雄辩的laravel ORM中编写查询.

I have this query that I am having trouble to write query in laravel eloquent ORM.

感谢某人可以提供帮助.

Appreciate if someone can help.

这是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)

推荐答案

尝试类似的方法:

DB::table('delivery_sap')
    ->whereNotIn('cust', DB::table('customer')->pluck('cust'))
    ->whereNotIn('cust_no', DB::table('customer')->pluck('cust_no'))
    ->select('cust', 'cust_no')
    ->groupBy('cust', 'cust_no')
    ->get();

这篇关于Laravel Eloquent在子查询中带有两个"WHERE NOT IN"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！