Oracle Internal Connectivity ____oracle

An inner join (Inner join) is a connection result of a table connection that contains only those records that fully satisfy the join condition.

Select T1.col1,t1.col2,t2.col3 from
t1,t2
where t1.col2=t2.col2

Or

Select T1.col1,t1.col2,t2.col3 from
T1
join T2 on (t1.col2=t2.col2)

If the inner join has additional restrictions in addition to the join condition, the position that the constraint appears in the target SQL does not affect the results of the final execution. If you want to add a t1.col1=1 present condition, this time you can write as follows:

Select T1.col1,t1.col2,t2.col3 from
T1
join T2 on (T1.col2=t2.col2 and T1.col1=1)

Or

Select T1.col1,t1.col2,t2.col3 from
T1
join T2 on (t1.col2=t2.col2)
where t1.col1=1

"Note": if it is outside the connection, it will affect the