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 vote293 views1 answer
Second Step in installing SQL workbench
SQL
15 votes315 views4 answers
Create table if not exists sql
SQL
3 votes287 views2 answers
Sql end of month
SQL
0 vote280 views1 answer
Postgresql alter column nullable
SQL
0 vote236 views1 answer
Check if has alpha characters sql
SQL
0 vote269 views1 answer
Power query datetime to date
SQL
0 vote290 views1 answer
Drop constraint in ms sql
SQL
3 votes287 views2 answers
Current year sql
SQL
0 vote274 views1 answer
Drop all procedures sql server
SQL
11 votes300 views2 answers
You are using safe update mode
SQL