Donald Trenholm
Last answered:

17 Mar 2023

 Posted on:

17 Mar 2023
0

Resolved: Getting an error 1049

in SQL / SQL Self Join

I'm getting an error 1049 when I run the query from the lesson. Any help?

2 answers ( 1 marked as helpful)
Tsvetelin Tsonkov
Instructor
Posted on:

17 Mar 2023
0

Hi Donald!
Thanks for reaching out.

It is because you typed emp.manager instead of emp_manager. Since, there is no such a database, error 1049 will occur. If there is such a table, it will check for table manager.


Hope this helps.
Best,
Tsvetelin

Donald Trenholm
Posted on:

17 Mar 2023
0

Thanks, I have to watch out for that. Everything looks the same after hours of looking at the computer.

Helpful answer

Submit an answer

related questions

THOMAS BELL
1
16
14. SQL JOINs - Error Code: 1055 (only_full_group_by)
yenni kosasih
0
14
error code 1140 : in aggregated query without group by
Donald Trenholm
0
14
Resolved: Getting error code 1140 even after trying the fixes.
abiola Emili
0
12
Resolved: error 1055 im mysql project
Christopher Watts
1
12
Error Code: 1364. Field 'customer_id' doesn't have a default value
Joe
1
12
Resolved: S Error code 1055
Maimuna Khatoon
0
12
Resolved: Getting Null as the result from all stored procedure queries including the assignment too.
BAO QUOC NGUYEN
0
10
Resolved: Error Code: player_err_timeout
Matt Birch
0
10
Error after Error: Can't create a table this time
Fatma Amer
0
10
Resolved: I am getting an error when submitting the 2 codes in the exercise
Romeo Thomas
0
10
LEFT JOIN - Part I error
Jaycus Goh
2
10
Error Code: 1418 while creating function