Is there a performance improvement when using the JOIN vs WHERE clause?

Question

Is there a performance difference (or any other reason) for using a JOIN instead of a WHERE clause according to the code examples below:

EX1.

select *
from table_1, table_2
where table_1.id=table_2.id;

ex2.

select *
from table_1
    join table_2 on
    table_1.id = table_2.id;

Answer 1

: : JOIN ( SQL Server, Oracle ). Comma JOINS . JOINS, , . , . JOINS (.. ) SQL- 1992 .

Oracle, LEFT JOINS RIGHT JOINS, (+) , . . , JOINS ( 2 ) .