jeudi 14 juillet 2016

Complex Query (With Three Level Subqueries) with Query Builder in Laravel 5?

I have the query like this:

SELECT p.*, t3.gambar_meteran, t3.angka_meteran from pelanggan p LEFT JOIN (SELECT t1.* FROM tagihan t1 JOIN (SELECT no_rek_pelanggan, MAX(created_at) created_at FROM tagihan GROUP BY no_rek_pelanggan) t2 ON t1.no_rek_pelanggan = t2.no_rek_pelanggan AND t1.created_at = t2.created_at) t3 ON p.no_rek = t3.no_rek_pelanggan

How can i use that complex query in laravel 5.2?

I Have try many ways like using DB::raw, DB:statement, etc. Help me please. Thank you..

Aucun commentaire:

Enregistrer un commentaire