Monday, March 6, 2017

Left Join query in laravel

how to query like

SELECT count(DISTINCT a.client_invoice_id) from client_invoice a LEFT JOIN document b on(a.client_invoice_id = b.relation_id_invoice) WHERE a.client_invoice_id IS NOT null and b.type_document = 'client_invoice'

in laravel version?



via dwiky aliansyah

Advertisement