SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what is difference between Ansi and Non Ansi based join.

BikramApr 30 2022

Hi Expert,
I have a doubt between Ansi and Non Ansi based join.In Ansi the joining is performed based on the table sequence which we have provided.for below query
But non Ansi, does table sequence matter? because we separate the table by commas(,) and we provide the join condition in where clause.
Regards,
Bikram

Added on Apr 30 2022

#sql

3 comments

4,277 views

1 mention