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

24 votes204 views5 answers
List mysql users
SQL
9 votes216 views3 answers
Mysql run sql file
SQL
2 votes234 views1 answer
Sql server: select column values as comma separated string
SQL
31 votes264 views4 answers
Mysql grant execute
SQL
0 vote204 views1 answer
Sql server concat null
SQL
0 vote180 views1 answer
Postgres create database if not exists
SQL
0 vote206 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
8 votes188 views5 answers
Alter table add column with default value
SQL
0 vote200 views1 answer
Populate db from command line postgres
SQL
1 vote232 views1 answer
Round one decimal place mysql
SQL