When joining tables in oracle is it preferred to use the traditional approach:
select
a.field1, b.field2
from
table1 a, table2 b
where
a.id = b.id
or the Ansi standard approach:
select
a.field1, b.field2
from
table1 a
inner join
table2 b
on
a.id = b.id
I’m new to oracle but I’ve used sql server a decent amount. I prefer the Ansi Standard but I was wondering what the preferred method is for oracle databases.
Thanks