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