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

23 votes207 views6 answers
Create table sql
SQL
0 vote218 views1 answer
Connexion mysql
SQL
-1 vote225 views1 answer
Concat two columns in sql server
SQL
5 votes207 views3 answers
Sql make column nullable
SQL
3 votes200 views1 answer
Get all elements sql
SQL
23 votes236 views4 answers
How to show all users in mysql
SQL
0 vote207 views1 answer
Sql roll up rows into columns
SQL
3 votes243 views3 answers
1396(hy00) mysql error
SQL
0 vote218 views1 answer
Reset keys in sql
SQL
19 votes240 views3 answers
How to change column type psql
SQL