我正在嘗試從faculties表中獲取數(shù)據(jù)。但我選擇enrolments. 基本上我的想法是顯示course那些被錄取的教師名稱和部分我嘗試了所有連接,但沒有任何效果。我很困惑如何加入 Laravel Eloquent。$results = Enrollment::select( 'students.rollnumber as student_rollnumber', 'courses.name as course_name', 'courses.course_code', 'sections.name as section_name', 'faculties.fname as faculty_fname', 'faculties.lname as faculty_lname' )->join( 'courses', 'courses.id', 'enrollments.course_id' )->join( 'students', 'students.id', 'enrollments.student_id' )->join( 'sections', 'sections.id', 'enrollments.section_id' )->join( 'faculties', 'faculties.section_id', 'enrollments.section_id' )->join( 'faculty_course_details', 'faculties.id', 'faculty_course_details.faculty_id' )->where('enrollments.student_id',9) ->get();錯誤:SQLSTATE [42S22]:柱未找到:1054未知列在'字段列表' 'faculties.fname'(SQL:選擇students。rollnumber如student_rollnumber,courses。name如course_name,courses。course_code,sections。name如section_name,faculties。fname如faculty_fname,faculties。lname作為faculty_lname從enrollments內(nèi)連接courses上courses。id= enrollments。course_id內(nèi)加入students上students。id= enrollments。student_id內(nèi)連接sections上sections。id= enrollments。section_id其中enrollments。student_id= 9)
- 3 回答
- 0 關(guān)注
- 116 瀏覽
添加回答
舉報
0/150
提交
取消