Equi joins in oracle

SELECT first_name, job_id, departments.department_id, department_name
FROM employees, departments
WHERE employees.department_id = departments.department_id
ORDER BY last_name, job_id;

Similar codes

21 votes255 views3 answers
Sql average
SQL
0 vote289 views1 answer
Sql to excel pgadmin
SQL
10 votes272 views4 answers
Drop primary key
SQL
0 vote249 views1 answer
Inser into example
SQL
1 vote291 views1 answer
Oracle plan hash value
SQL
0 vote246 views1 answer
A network or instance-specific error sql server
SQL
0 vote202 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote262 views1 answer
Test database for sql
SQL
6 votes247 views1 answer
What is where clause in sql
SQL
16 votes252 views6 answers
Insert sql
SQL