Can you please try with below.
$dbkompetenzen = DB::table('LD_Kompetenzen') ->leftjoin('LD_SHD','LD_Kompetenzen.id','=', 'LD_SHD.KompetenzID') ->where('LD_Kompetenzen.FachID','=',$idfach) ->where('LD_Kompetenzen.ThemenID','=',$idthemen) ->where('LD_SHD.SHDID','=',$shdid) ->select('LD_Kompetenzen.id', 'LD_Kompetenzen.FachID', 'LD_Kompetenzen.ThemenID', 'LD_Kompetenzen.Kompetenz', 'LD_SHD.SHDID', 'LD_SHD.Ergebnis', 'LD_SHD.Stufe', 'LD_SHD.Niveau', 'LD_SHD.Note', 'LD_SHD.Datum', 'LD_SHD.Kuerzel', 'LD_SHD.background') ->get();
I discovered the Join ON function. This makes my project work!
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community