I'm trying to print out from array into view but it always says ('Illuminate\Database\QueryException with message 'SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'stations' (SQL: select * from stations
inner join stations
on stations
.id
= users
.station
)'
This is function inside controller
public function show()
{
$users = App\Classes::join('stations','stations.id','=', 'users.station');
return view('configuration.configuration', compact($users));
}
This is model Stations and model users
public function user()
{
return $this->hasMany('App\User');
}
public function razred()
{
return $this->belongsTo('App\Classes');
}
and the foreign key is in table users
$table->integer('station')->nullable()->unsigned()->default(null);
$table->foreign('station')->references('id')->on('stations')->onDelete('cascade');
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire