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

1 vote309 views1 answer
Concat first name and last name in mysql
SQL
7 votes315 views2 answers
Sql remove duplicates based on column
SQL
10 votes316 views6 answers
Mysql set root password
SQL
0 vote295 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote259 views1 answer
Sql query with date
SQL
0 vote270 views1 answer
Sql change date format
SQL
0 vote249 views1 answer
Import all databases mysql
SQL
3 votes273 views2 answers
Get current year sql
SQL
0 vote270 views1 answer
Mysql search multiple tables
SQL
0 vote270 views1 answer
Jdbc sql connection string
SQL