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

0 vote139 views1 answer
Download sql file of countries names
SQL
2 votes172 views2 answers
Null column to 0 in mysql
SQL
5 votes152 views1 answer
Oracle nls parameters
SQL
9 votes129 views2 answers
Mysql change value
SQL
1 vote131 views1 answer
Select if then postgresql
SQL
22 votes119 views2 answers
Mysql show all tables
SQL
2 votes132 views4 answers
Mysql select into new table
SQL
0 vote128 views1 answer
Sql case when exists in another table
SQL
0 vote129 views1 answer
How to find all children of a record with only parent ID in sql
SQL
58 votes309 views6 answers
Create new user in postgres
SQL