Join query return duplicate data in laravel

Question

I have run a join query based on client_id between directsales and clients table. but when i print the query result it's show duplicated data.

here, is my code.

public function readirectsalereport(Request $request)
{
    $client_id=$request->client_id;
    $fromdate=$request->frmdate;
    $todate=$request->todate;

        $dsale=DB::table('directsales')
            ->join('clients','directsales.client_id','=','clients.id')
            ->select('clients.client_name','clients.addr')
            ->where('directsales.client_id','=',$client_id)
            ->get();

            return $dsale;

}

and it's show this result.

[{"client_name":"majed10","addr":"Uttara"},{"client_name":"majed10","addr":"Uttara"}]

INNER JOIN's can return duplicated records indeed. Laraval's function distinct() should help you out here. — Raymond Nijland
– Raymond Nijland, Commented Dec 1, 2017 at 16:26

Laerte · Accepted Answer · 2017-12-01 16:44:32Z

8

Use distinct method:

$dsale=DB::table('directsales')
            ->join('clients','directsales.client_id','=','clients.id')
            ->select('clients.client_name','clients.addr')
            ->where('directsales.client_id','=',$client_id)
            ->distinct()
            ->get();

Ref: https://laravel.com/docs/5.5/queries#selects

answered Dec 1, 2017 at 16:44

Laerte

7,0833 gold badges35 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Gabrielle-M Over a year ago

if, I want to add sum function in this query. how can i ??

Laerte Over a year ago

You can add a raw query in it, but maybe it will not work with distinct. You can try with groupBy, it should fit the problem.

EmilyH Over a year ago

I appreciate this answer! The Laravel documentation inside the Database section has a single reference to distinct() in an example and no notes on it at all.

Appoodeh Over a year ago

not working for me

Collectives™ on Stack Overflow

Join query return duplicate data in laravel

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related