Showing posts with label When we should use inner join and sub query?. Show all posts
Showing posts with label When we should use inner join and sub query?. Show all posts

Tuesday, 12 May 2015

When we should use inner join and sub query?

When we should use inner join and sub query?
  • Use joins when we need to get data from both the tables in SELECT statement.
  • Use sub query when we need to get data from only one table and other table is used only to check existence.