Hey gang, Trying to figure out how to code up a query to take the results of one table, and multiple results from a second table, and collect'em up in a single recordset.
One table is horizontal (one row = one record), second table is vertical (one row in first table could have several related records in second table). So say here's my tables, with some example data: First table: ID / Name 1 / Joe Second table: Name / Order / Value Joe / 1 / Blue Joe / 2 / Vanilla What I want to end up with is a recordset like: ID / Name / 1 / 2 1 / Joe / Blue / Vanilla Doing one join is simple enough - I'm struggling with being able to code up multiple joins. In records, I'll have no records in the second table for a given row in the first - others, I'll have varying amounts of secondary records. Any pointers or shoves in the right direction would be appreciated. :) --Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
