Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
5
Reply
SQL Query Joins
Kritika Singh
Jan 7 2016 5:46 AM
379
Reply
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.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
5
)
Next Recommended Forum
Want to Sort column first name in alphabetical order.
How to add in other whenever came from Public holiday date