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

1 vote167 views2 answers
Mysql order by date asc null last
SQL
9 votes159 views4 answers
Add primary key to existing table sql
SQL
16 votes169 views1 answer
CTE statement sql server
SQL
7 votes195 views6 answers
Mysql group concat
SQL
6 votes193 views1 answer
How to get the size of the database in postgresql
SQL
0 vote182 views1 answer
Datagrip execute procedure
SQL
0 vote175 views1 answer
Install postgresql 12 on debian 10
SQL
9 votes167 views3 answers
Where in sql
SQL
4 votes195 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote163 views1 answer
Oracle list index on table
SQL