This question already has an answer here:
- Laravel 4 eloquent WHERE with OR AND OR? 7 answers
I'm trying to get the sum of two team score but it returns null.
DB::table('team_competition_statistics')
->select([
DB::raw('SUM(sGames) AS GP'),
DB::raw('SUM(sPointsAverage) as AVGP'),
DB::raw('SUM(sAssistsAverage) as AVGA'),
DB::raw('SUM(sReboundsTotalAverage) as AVGR'),
DB::raw('SUM(sStealsAverage) as AVGS'),
DB::raw('SUM(sBlocksAverage) as AVGB')
])
->where('competitionId', $competitionId)
->where('periodNumber', 0)
->where('teamId', $id1)
->where('teamId', $id2)
->get();
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire