Hi all, I have two queries from two different datasources I need to combine.
The first query is <cfquery name="query1" datasource="ds1"> SELECT EmailWizardStepKey, Completed FROM #Client.DBPrefix#.vuEmailWizardStepStatus WHERE EmailJacketKey = <cfqueryparam cfsqltype="cf_sql_integer" value="#Client.EmailJacketKey#"> AND USERKEY = <cfqueryparam cfsqltype="cf_sql_integer" value="#Client.UserKey#"> </cfquery> The second query is: <cfquery name="query2" datasource="ds2"> SELECT EmailWizardStepKey, P2P, DPF, Title FROM EmailWizardStep </cfquery> I am needing to combine the two queries so I can loop through them and output everything. Any ideas? TIA --------------------------------- Do you Yahoo!? Yahoo! Search - Find what you�re looking for faster.
