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

5 votes319 views1 answer
Oracle sysdate
SQL
0 vote319 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote334 views1 answer
Select amount weeks between two dates mysql
SQL
4 votes332 views1 answer
T-sql get duplicate rows
SQL
0 vote307 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote319 views1 answer
Mysql into outfile with headers
SQL
9 votes346 views6 answers
Replace sql
SQL
3 votes381 views1 answer
Oracle undo tablespace schema
SQL
1 vote319 views1 answer
Set statistics on in ssms
SQL
4 votes326 views3 answers
Mysql modify foreign key
SQL