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

0 vote346 views1 answer
QCompleter con sql
SQL
54 votes542 views6 answers
Sql rename column
SQL
3 votes324 views3 answers
Sql current year
SQL
0 vote283 views1 answer
Online sql compiler
SQL
0 vote384 views1 answer
Write SQL in ruby on rails
SQL
0 vote360 views1 answer
Mysql db dump restore max file size issue
SQL
-1 vote343 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote325 views1 answer
Mql5 list all available symbols
SQL
1 vote345 views2 answers
How to check if sql query is correct online
SQL
1 vote349 views3 answers
Rename table snowflake
SQL