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 votes336 views2 answers
How to get capital letter first in sql
SQL
14 votes349 views3 answers
Sql trim from string
SQL
0 vote362 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
8 votes320 views3 answers
Duplicate entry
SQL
1 vote296 views1 answer
Unique vs distinct sql
SQL
0 vote403 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
8 votes381 views4 answers
Postgresql server restart
SQL
0 vote436 views1 answer
Trigger
SQL
10 votes343 views2 answers
Sql merge statement
SQL
6 votes335 views2 answers
WHERE value IS sql
SQL