Why the query throws an error "Not unique table/alias: 'Films'"?

SELECT
Tickets.number_row,
Tickets.number_place,
sessions.id_hall,
sessions.date_sessions,
sessions.start_time,
films.name_film
FROM
 Tickets, sessions, films
INNER JOIN Tickets ON sessions.id_session = Tickets.id_session
INNER JOIN sessions ON films.id_film = sessions.id_film;
April 3rd 20 at 18:46
0 answer

Find more questions by tags MySQL