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

2 votes364 views2 answers
Install postgresql
SQL
15 votes377 views4 answers
Mysql where value is null
SQL
0 vote345 views1 answer
Install postgresql 12 on debian 10
SQL
79 votes631 views6 answers
Grepper code
SQL
-1 vote359 views1 answer
What is in operator
SQL
0 vote345 views1 answer
Copied text from internet not inserting in mysql
SQL
5 votes334 views2 answers
Oracle tables with column name
SQL
0 vote347 views1 answer
Oracle flush Shared Pool
SQL
0 vote329 views1 answer
Access refused mysql xampp server
SQL
3 votes341 views1 answer
Sql datetime as date
SQL