Microsoft SQL Server
SQL Server Tutorial, Query's and Interview Questions
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.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment