Data pivot problem (brain isn't working right today)

Syntax not exact, but this is the process. <cfquery name="getStrats> Select Stratification from Target_Stratifications </cfquery> <cfquery name="getTargets"> Select Target_Type from Target_Types </cfquery> <table> <!--- Set headings ---> <tr> <td>Name</td> <cfloop query = "getTargets"> <td>#Target_Type#</td> </cfloop> </tr> <!--- Do Table ---> <cfloop query = "getStrats"> <tr> <td>#Stratification#</td>    <cfloop query = "getTarget">    <cfquery name= "getTargetTargets">     select * from Target_Targets     where Stratification = getStrats.Stratification and Target_type = getTargets.Target_type    </cfquery>    <td>#getTargetTargets.Target#</td>    </cfloop> </tr> </cfloop> </table> > > Hi all, > > > > Got a problem trying to convert a many to many relationship to a grid. > > > > There are three tables (defined below), and I need the output in a > certain way (also defined below). I've done this before, but for the > life of me I can't remember how. > > > > Table 1 (Target_Stratifications): > > Stratification varchar(100) not null primary key > > Strat_owner varchar(100) not null > > > > Table 2 (Target_Types): > > Target_type varchar(15) not null  primary key > > Target_default numeric(9, 4) not null default 0 > > Target_Tolerance numeric(9, 4) not null default 0 > > > > Table 3 (Target_Targets): > > Stratification varchar(100) not null > > Target_type varchar(15) not null > > Target numeric(9, 4) not null default 0 > >  *Primary Key (stratification, target_type) > >  * [Stratification] References Target_Stratifications.stratification > [on update cascade, on delete cascade] > >  * [target_type] References Target_Types.target_type [on update > cascade, on delete cascade] > > > > It's a pretty normalized set of tables. In stratifications is a list of > proper names, and in target types is the Proper name for the target of > the measure that is being worked on along with default values and > tolerances. > > > > I need to get the data in this format (| used just to separate the > columns, the actual result will be put in a cfgrid): > > Stratification|Target_Type(1)|Target_Type(2)|Target_Type(3)|Target_Type( > 4)|...|Target_Type(n) > > Steve|100|50|25|10|...|15 > > Mike|25|75|2|100|...|75 > > > > Can someone push me in the right direction? > > > > Thanks, > > Steve > > > > > >