• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Day 19. Using Advanced SQL Techniques > Understanding SQL Subqueries

Understanding SQL Subqueries

As you might expect, a SQL subquery is a SELECT within a SELECT. In a way, subqueries are similar to table joins, but certain situations may benefit from using one method rather than the other.

Take a look at a couple of TV Cop Pasta's tables in Figures 19.9 and 19.10.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint