Support the ongoing development of Laravel.io →
saschaschr
posted 1 year ago
Database Lumen
Last updated 10 months ago.
0
ramiltk
replied 1 year ago
Solution

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
saschaschr
replied 1 year ago

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

Last updated 1 year ago.
1

Sign in to participate in this thread!

LoadForge

Your banner here too?

Sascha saschaschr Joined 11 Jul 2021

Moderators

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

Beyond Code
Fathom
Forge
Envoyer
LaraJobs
LoadForge
Skynet Technologies
Lightflows

Your logo here?

Laravel.io

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

Laravel.io

Forum Articles Pastebin

Socials

Twitter GitHub

The community

Laravel Laravel Laravel News Laravel News
Laracasts Laracasts Laravel Podcast Laravel Podcast
© 2023 Laravel.io - All rights reserved.
Terms of service Privacy policy Advertise