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

9 votes127 views3 answers
Where clause sql
SQL
0 vote112 views1 answer
Reona
SQL
0 vote68 views1 answer
Mysql find foreign key references
SQL
1 vote111 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
8 votes97 views1 answer
Ltrim sql
SQL
0 vote119 views1 answer
Mysql get first 2 characters of string
SQL
11 votes100 views2 answers
Insert date sql
SQL
0 vote90 views1 answer
Sql menampilkan data tabel
SQL
0 vote120 views1 answer
Executescalar in sql server
SQL
4 votes118 views2 answers
DB::transaction
SQL