i wont to make this query :
SELECT w.wilayah, a.penerima
FROM (
SELECT DISTINCT wilayah FROM lokasi
) w
LEFT JOIN (
SELECT COUNT(*) penerima, kota_kab AS wilayah
FROM alamat_penerima
GROUP BY kota_kab
) a ON w.wilayah = a.wilayah
to laravel query, thanks i hope you can help me
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community