1
I’m trying an INNER JOIN between 3 more tables returns error, I don’t know what’s wrong. Query:
SELECT
aa.arq_arqid,
aa.arq_nome,
aa.arq_nomecrip,
aa.arq_datetime,
u_usuarios_u_userid
a_area_a_areaid
FROM arq_arquivos as aa
INNER JOIN u_usuarios as usr
ON u_usuarios_u_userid = usr.u_userid
INNER JOIN a_area as ar
ON a_area_a_areaid = ar.a_areaid
a comma is missing after u_usuarios_u_userid
– Marcelo Diniz
Really missing a comma, but still an error. #1054 - Unknown column 'u_usuarios_u_userid' in 'field list'
– wilian
No table has the column u_usuarios_u_userid, only u_usuarios_u_useid, missing a R
– user1811893
@user1811893 problem solved, grateful.
– wilian