SELECT * FROM table_a, b WHERE table_a.id = b.id AND table_a.status ='success'
Why is the second format used and not the first one?? Is it due to performance reasons?
If yes then how or why. Please explain in detail.
If yes then how or why. Please explain in detail.
Gowtham KPosted Jan 19, 2016, 2:23 AM
Kritika SinghPosted Jan 19, 2016, 1:58 AM
Francis SusaimichaelPosted Jan 11, 2016, 6:41 AM
If a WHERE clause is added to a cross join, it behaves as an inner join as the WHERE imposes a limiting factor.
Kritika SinghPosted Jan 11, 2016, 6:30 AM
In the link it is stated that the second one is ANSI standard. Does it make any difference??
Francis SusaimichaelPosted Jan 7, 2016, 6:56 AM