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 votes184 views1 answer
Alter table add multiple columns postgresql
SQL
0 vote195 views1 answer
GROUP BY postgres
SQL
0 vote236 views1 answer
Postgresql remove new line from string
SQL
2 votes188 views2 answers
Useradd postgres
SQL
2 votes185 views1 answer
Wait delay in sql server
SQL
2 votes242 views3 answers
Mysql cheat sheet
SQL
1 vote250 views1 answer
Postgres select as csv
SQL
19 votes186 views2 answers
Mysql tinyint max value
SQL
0 vote215 views1 answer
Sqlite version check
SQL
0 vote218 views1 answer
Oracle list dblink
SQL