samedi 5 janvier 2019

SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias in laravel -{duplicate}


Iam a new beginer of laravel.
Now, Iam learning relationship part of laravel.
I see many question like it !! But no answer is not good for me.
I see this error :

SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'tbl_education_iteams' (SQL: select * from `tbl_education_iteams` inner join `tbl_education_iteams` on `tbl_education_groups`.`id` = `tbl_education_iteams`.`group`)

I wrote my Query in Controller :

$education_iteam = DB::table('tbl_education_iteams')
->join('tbl_education_iteams','tbl_education_groups.id','=','tbl_education_iteams.group')
        ->select()
        ->get();



from Newest questions tagged laravel-5 - Stack Overflow http://bit.ly/2LQO5C8
via IFTTT

Aucun commentaire:

Enregistrer un commentaire