Skip to Main Content

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!

First WHERE clause or JOIN clause

kishore_123Jun 26 2020 — edited Jun 26 2020

Team,  i'm asking a basic question ,getting this question in my mind whenever i use join along with where clause in my select  ,your answers is much helpfull.

Example:

Let's say I have two tables A and B and the following query:

select * from A inner join B on A.id = B.id Where A.id = 5

Does my sql first performs the join or the where?

This post has been answered by odie_63 on Jun 26 2020
Jump to Answer
Comments
Post Details
Added on Jun 26 2020
6 comments
4,934 views