boy18nj (112) [Avatar] Offline
book says-
You might have noticed that there is a world of difference between the following
from Bid b where = 1
from Bid b where b.item.description like '%gc'
The second query uses an implicit table join; the first has no joins at all.

But as far as i can say, both queries are using the implicit table join.

Can you please shed light on it?
boy18nj (112) [Avatar] Offline
Re: Page-269- Understanding the implicit join-
I got the answer-

In the first query there is no need to join as the is already available in the bid table due to the FK relationship .