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 vote173 views2 answers
Null value in column violates not-null constraint
SQL
0 vote173 views1 answer
Jdbc sql connection string
SQL
9 votes190 views1 answer
Alter table column change data type to text mysql
SQL
0 vote176 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
0 vote252 views3 answers
Get count of null in column sql
SQL
0 vote159 views1 answer
Sql remove last x char
SQL
1 vote158 views1 answer
Mysql datetime with timezone offset
SQL
0 vote172 views1 answer
Oracle sql date summer time
SQL
1 vote165 views1 answer
Right outer vs left outer join
SQL
0 vote168 views1 answer
Postgres list tables and row counts
SQL