FilamentF
Filament3y ago
MAF

How can I work around this `column reference "id" is ambiguous`?

// GradeResource.php

public static function getEloquentQuery(): Builder
{
    $query = parent::getEloquentQuery()
        ->join('schools', 'grades.school_id', '=', 'schools.id')
        ->select('grades.*', 'schools.name as school_name');
        ->where('schools.created_by', auth()->id());
}
Was this page helpful?