Looping through variables

Was hoping that someone could help me loop through a series of variables.
My relevant code is

<cfset Product_Name = GetMortgages.Product_Name>
<cfset Initial_Interest_Rate6 = GetMortgageRates6.Initial_Interest_Rate>
<cfset Initial_Interest_Rate12 = GetMortgageRates12.Initial_Interest_Rate> etc

I then want to loop through all the records and display them in separate cells as follows.

<cfoutput>
<tr>
<td>#Product_Name#</td>
<td>#Initial_Interest_Rate6#</td>
<td>#Initial_Interest_Rate12#</td>
</tr>
</cfoutput>

Unfortunatley the above only gives me the first records and
not the entire list of product names in unique rows.

thanks in advance for any help you can provide

perhaps
<cfoutput query="GetMortgages">
#productname#
</cfoutput>

?

This ends up producing too many repeated records. i.e it replicates the product name and interest rates multiple times in mutilple rows.

The Tables structure is

Product_Name.Mortgages
Initial_Interest_Rates.Mortgage_terms

These tables are joined by a field called mortgage_id

any other suggestions?