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 vote171 views1 answer
Hotw to alter lengh character vayng postgres
SQL
4 votes157 views1 answer
Wilayah indonesia database
SQL
0 vote158 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote159 views1 answer
Components/Fields of Internal Table
SQL
0 vote157 views1 answer
Sql delete from with relation
SQL
8 votes165 views3 answers
SQL column name
SQL
0 vote168 views1 answer
Get the Db column names from a SqlDataReader
SQL
19 votes157 views5 answers
Date between in mysql
SQL
3 votes149 views1 answer
Two selects in one query
SQL
0 vote150 views1 answer
Report in database
SQL