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 vote205 views2 answers
Remove space in mysql
SQL
3 votes180 views3 answers
How to add month in update sql
SQL
0 vote195 views4 answers
Forenkey code alchemy sql
SQL
0 vote190 views1 answer
Mysql regex select
SQL
0 vote182 views3 answers
Between keyword sql
SQL
0 vote203 views10 answers
Sql statement checker corrector
SQL
0 vote174 views1 answer
Sauvegarde complète my sql
SQL
1 vote210 views1 answer
Oracle user last connection date
SQL
0 vote177 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote201 views2 answers
How to login to mysql as normal user in ubuntu
SQL