I am starting the process of upgrading one of my clients' test server in preparation to upgrading their production server from CF2016 to CF2021 and am seeing some strange QoQ behaviour. I was able to reduce the code to the following: <!---
SQL Server backend
create table qoq1 (id int,name varchar(10))
insert into qoq1 select 1,'One' union select 2,'Two' union select 3,'Three'
create table qoq2 (appid int,name varchar(10))
insert into qoq2 select 1,'Uno' union select 2,'Dos' union select 3,'Tres'
--->
<CFQuery Name="q1b" DataSource="myds">
select qoq1.id,qoq1.name from qoq1 order by qoq1.name
</CFQuery>
<CFQuery Name="q2b" DataSource="myds">
select qoq2.name as catname,qoq2.appid from qoq2 order by qoq2.name
</CFQuery>
<CFQuery Name="q3b" DBType="Query">
select q2b.catname,q1b.*
from q1b,q2b
where q1b.id=q2b.appid
order by q2b.catname,q1b.name
</CFQuery>
<CFDump Var="#q3b#"> The above dump in CF2016 shows 4 columns (which
AdChoices