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

Day 19. Using Advanced SQL Techniques > Understanding Table Joins

Understanding Table Joins

A table join is pretty much what it sounds like—using a single SQL statement to pull records from two different tables and presenting the results to ColdFusion as a single batch. Why would you want to do this? Check out the tables in Figures 19.7 and 19.8.

Figure 19.7. The customers table from TV Cop Pasta, Inc. displays shipping and contact infor mation.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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