0

enter image description here

select 
       ID_WORKERS, name, ID_JOB, NAME_JOB
       NAME_WORKERS,
       AGE,
       GENDER,
       PHONE_WORKERS,
       ADRESS
FROM WORKERS INNER JOIN JOB 
ON ID_JOB = ID_WORKERS
PeterT
  • 8,232
  • 1
  • 17
  • 38
Nikita Vinnikov
  • 1
  • in the screenshot it gives an error in line 8 – Nikita Vinnikov Jun 03 '22 at 16:23
  • I don't think JOB is a reserved word but you could wrap it in quotes to ensure it's not but there definitely is a syntax error in the missing comma between Name_Job Name Workers. See if putting that in changes the error message. – xQbert Jun 03 '22 at 17:32
  • Explicitely state where your columns are coming from in your query, i.e. JOB.ID_WORKERS. This will help you troubleshoot this problem in the future. – VvdL Jun 03 '22 at 17:36

1 Answers1

0

You are missing a comma between NAME_JOB and NAME_WORKERS.

Mark Roberts
  • 138
  • 7