I am running a query,
<cfquery name="getRecords" datasource="******">
SELECT Prods.*, ProdMatrix.*, Categories.*
FROM Prods, ProdMatrix, Cats
WHERE (Prods.ProdID = ProdMatrix.ProdID) AND (Prods.CatID = Cats.CatID)
</cfquery>
All information is displaying properly. What I would like to do is show...