Im wondering what is the best way to get related data from two tables. This would be the MySQL database structure:
Table Name: Category CategoryID (autonumber) CategoryName (text) Table Name: Subcategory SubcategoryID (autonumber) SubcategoryName (text) Table Name: Product ProductID (autonumber) CategoryID (linked to category table) SubcategoryID (linked to subcategory table) ProductSKU (text) If i know the ProductID, what is the BEST way to get the CategoryName, and SubcategoryName? Two Querys (one in a CFLOOP) ? Query inside of a Query ? INNER JOIN ? WHERE Product.CategoryID = Category.CategoryID ? Thanks In advanced, Chad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
