php - 在 laravel 中左连接查询

Question

如何查询like

SELECT count(DISTINCT a.client_invoice_id)
来自 client_invoice 的 LEFT JOIN
文档 b on(a.client_invoice_id = b.relation_id_invoice)
其中 a.client_invoice_id 不为空
和 b.type_document = 'client_invoice'

在 laravel 版本中？

Answer 1

$result = DB::table('client_invoice as a')
->leftjoin('document as b', 'a.client_invoice_id', '=', 'b.relation_id_invoice')
->whereNotNull('a.client_invoice_id')
->where('b.type_document', '=', 'client_invoice')
->distinct()
->count();