[ORACLE] TABLE JOIN IN SQL

When I want to join with tables, you need to use JOIN function

For example,

TABLE_1: EMPLOYEES

TABLE_2: EMP_DETAILS_VIEW

 

And if the colume is same as COLUME

 

THEN,

 

SELECT *

FROM TABLE_1 A JOIN TABLE_2 B ON A.COLUME = B.COLUME;

 

Refer to the following example

 

SELECT *
FROM EMPLOYEES A JOIN EMP_DETAILS_VIEW B ON A.EMPLOYEE_ID = B.EMPLOYEE_ID;