samedi 20 octobre 2018

How To Write A Laravel Join Containing A Select Of MySQL User Defined Variables

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