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.
Figure 19.8. The orders table from TV Cop Pasta, Inc. displays order details for each customer.
Recall that when the TV Cop Pasta database was created in Day 4, the ...