vendredi 17 février 2017

Select count of rows in another table in a Laravel

I don't know quite how to phrase this in Laravel query-builder so please help me .

SELECT A.*, (SELECT COUNT(*) FROM B WHERE B.a_id = A.id) AS TOT, (SELECT COUNT(*) FROM C WHERE C.a_id = A.id) AS KOK FROM A



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire