Kritika Singh

Kritika Singh

  • NA
  • 17
  • 4.4k

SQL Query Joins

Jan 7 2016 5:46 AM
SELECT * FROM a JOIN b ON table_a.id = b.id WHERE table_a.status ='success'
 
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.

Answers (5)