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 votes242 views1 answer
Tcl in sql
SQL
2 votes283 views1 answer
Brew start postgres manual
SQL
0 vote193 views1 answer
Postgres jsonb array push new element
SQL
0 vote241 views1 answer
Create a plsql object
SQL
3 votes219 views1 answer
Mysql replace string in table
SQL
0 vote200 views1 answer
How to create a table based on another table in mysql
SQL
2 votes187 views1 answer
Mysql query unique column
SQL
14 votes189 views4 answers
Remove record from table sql
SQL
0 vote149 views1 answer
Microsoft sql server management studio clear cache
SQL
6 votes214 views1 answer
Allsource oracle
SQL