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.