How can i use this script in laravel controller?
SELECT MAX(branch_tbl.branch_name) AS Branch_Name, COUNT(staffinfo.branchID) AS Count_Branch
FROM branch_tbl
LEFT JOIN staffinfo ON staffinfo.branchID = branch_tbl.branch_id
GROUP BY branch_tbl.branch_id;
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire