select * from acces
inner join table1 as players on joueur.champs1 as #1
= players.champs2


where acces.code like concat('%','Lo','%');