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 ...
Get Sams Teach Yourself ColdFusion® in 21 Days now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
