I have a question, I do not remember the conditions in Mysql, I'm doing consultations with Inner join and reserved words.
SELECT (Nombre_empresa) FROM (empresa)
INNER JOIN (lucha)
ON (id_empresa=id_lucha)
WHERE condiciones_para_cualquier_campo_de_cualquier_tabla
Thanks! I'm waiting for an answer.
InnerJoin will look for the values in common that have 2 tables according to the "where" filter (optional) that you indicate, what you must take into consideration is that the tables to which you make references must have values that MATCH, example.
SELECT nombre_columnas
FROM tabla1
INNER JOIN tabla2 ON tabla1.nombre_columnas = tabla2.nombre_columnas
WHERE tabla2.nombre_columnas='gabriel'
I do not know if that was your doubt, if it was not specifies what is your inconvenience so I can help you