Hi,
Is that something oracle recommends to join table using general syntax(in query tables separated by comma and join condition put in where clause) and not the ANSI syntax (using keyword like "INNER JOIN, LEFT OUTER JOIN etc") ans ANSI has become out of fashion these days.
Using general Syntax :
SELECT ...
FROM dataset_one d1
, dataset_two d2
WHERE d1.column(s) = d2.column(s)
AND ...
using ANSI Syntax (please let me know if this method of tbale joining is not preferred and out dated):
SELECT ...
FROM dataset_one d1
JOIN TYPE
dataset_two d2
ON (d1.column(s) = d2.column(s))
WHERE filter_predicates...
Thanks,
Vipin Kumar Rai