How to make a request in laravel?

Question

Laravel

Why does the on() method turn the alias dt into prefix_dt?
The muscle naturally swears at the lack of prefix_dt.idfd:
Unknown column 'prefix_dt.idfd' in 'on clause'

->leftJoin(DB::raw("(SELECT MAX(sdp.saledate) AS saledate, sdp.branch AS idfd FROM prefix_params sdp GROUP BY sdp.branch) AS dt"),
                function($join)
                {
                    $join->on('dt.idfd', "=", 'branches.id');
                });

Answer 1

it turns out that you need to wrap the field in DB:: raw ()
$join->on(DB::raw('dt.idfd'), "=", 'branches.id');