a quwstion about the logic behind the code

in SQL / JOIN more than two tables in SQL

Hi, what determens that the employees table would be the one we would select from..? (I have attached a screen shot) Thanks..!

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

21 Sept 2022

Hi Kfir!
Thanks for reaching out!

Actually, we are not selecting only from the employees table, but from the dept_manager, departments and titles tables. Also, we make a join between them. We determine the tables according to the needs of the task.

Hope this helps.
Best,
Tsvetelin

Submit an answer

related questions

THOMAS BELL

14. SQL JOINs - Error Code: 1055 (only_full_group_by)

Abdelrahman Samy

Resolved: why this code not valid

yenni kosasih

error code 1140 : in aggregated query without group by

Donald Trenholm

Resolved: Getting error code 1140 even after trying the fixes.

Christopher Watts

Error Code: 1364. Field 'customer_id' doesn't have a default value

Joe

Resolved: S Error code 1055

Jose Luis Loren

Alternative code using group by

Jyothi Reddy

where should I attach the code I executed for assignments

BAO QUOC NGUYEN

Resolved: Error Code: player_err_timeout

Jaycus Goh

Error Code: 1418 while creating function

Ioannis Dimitriadis

Resolved: Error Code: 1140

Zachary Roblyer

Error Code: 1231