I require to write a MySQL join statement in Laravel joining a select statement containing user defined MySQL variables. I have tried using ->join(DB::raw()) to no prevail. Using this join statement is the only way I am able to get the output I require. Would appreciate some help!!
JOIN (SELECT @curHODRow:=0, @curHOD:=0,@curYearRow:=0, @curYear:=0, @curMonthRow:=0, @curMonth:=0, @curPtypeRow:=0, @curPtype:=0, @curPcodeRow:=0, @curPcode:=0) v
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire