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 vote207 views1 answer
How to print some string in mysql
SQL
0 vote215 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote199 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
5 votes197 views1 answer
Ora-00054 find lock
SQL
0 vote187 views1 answer
Mysql sql select one day before
SQL
28 votes202 views6 answers
Mysql change user password
SQL
0 vote186 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote189 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote207 views1 answer
Create function in microsoft sql server
SQL
0 vote268 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL