INNER JOIN returning error

Asked

Viewed 162 times

1

I’m trying an INNER JOIN between 3 more tables returns error, I don’t know what’s wrong. imagens das 3 tabelas 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

  • Really missing a comma, but still an error. #1054 - Unknown column 'u_usuarios_u_userid' in 'field list'

  • 1

    No table has the column u_usuarios_u_userid, only u_usuarios_u_useid, missing a R

  • @user1811893 problem solved, grateful.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.