CODEWITHSUNDEEP
laravellaravel-query-builder
Oscar
Oscar

Reputation: 139

How to make a distinct in only one table of a join using Laravel Query Builder?

I have this query... and I would like to make a distinct only in (tbl_holdings)

This is my query 

$holdings = DB::table('tbl_perimetros')
                ->distinct()
                ->join('tbl_holdings', 'tbl_holdings.id', '=', 'tbl_perimetros.holdings_id')
                ->get();

Upvotes: 0

Views: 845

Answers (1)

TsaiKoga
TsaiKoga

Reputation: 13394

Use groupBy instead of distinct:

$holdings = DB::table('tbl_perimetros')
                ->groupBy('tbl_perimetros.holdings_id') 
                ->get();

Remove ONLY_FULL_GROUP_BY:

Add modes to the config/database.php

'mysql' => [
    ...
    'modes' => [
        'STRICT_ALL_TABLES',
        'ERROR_FOR_DIVISION_BY_ZERO',
        'NO_ZERO_DATE',
        'NO_ZERO_IN_DATE',
        'NO_AUTO_CREATE_USER',
    ],
],

Upvotes: 1

Related Questions