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 vote224 views1 answer
Alter owner in PostgreSQL
SQL
1 vote220 views1 answer
Apex select list ORA-20999
SQL
1 vote413 views1 answer
Foreign key in oracle sql developer
SQL
0 vote268 views3 answers
Mysqli count down
SQL
0 vote213 views1 answer
List mysql tables and views
SQL
0 vote218 views1 answer
How to check which table has data in mysql
SQL
0 vote185 views1 answer
Mariadb set vertical output format
SQL
3 votes263 views2 answers
Wp do sql query from function
SQL
0 vote199 views1 answer
Select from another database
SQL
0 vote198 views1 answer
Grant privileges of databse to user
SQL