Support the ongoing development of Laravel.io →
Database Lumen
Last updated 3 months ago.
0

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();

0

I discovered the Join ON function. This makes my project work!

Last updated 1 year ago.
1

Sign in to participate in this thread!

Cloudways

Your banner here too?

Sascha Sascha saschaschr Joined 11 Jul 2021

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

The Laravel portal for problem solving, knowledge sharing and community building.

© 2022 Laravel.io - All rights reserved.