i thought doing a union between two queries will g...
# lucees
Simone
06/22/2023, 5:05 PMi thought doing a union between two queries will get me distinct records, even in both queries i have one column being returned and almost same data but to be sure, i tried to use union but it got me everything
Copy code
<cfquery name="getCompiled" dbtype="query">
select distinct num1 from getAssignments
union
select distinct num1 from getCompleted
</cfquery>m
Michael Schmidt
06/22/2023, 6:23 PMVerified that Adobe CF does filter out duplicates in a query of queries union
https://trycf.com/gist/9b3e55db0db4a21c6536729ee494c898/acf2021?theme=monokai
Michael Schmidt
06/22/2023, 6:24 PMAnd Lucee 6 successfully does as well
Michael Schmidt
06/22/2023, 6:27 PMand lucee 5 does as well
b
bdw429s
06/22/2023, 7:37 PMCorrect. Older versions of Lucee 5 did not however. What CF engine/version are you on?
a
Asher Densmore-Lynn
06/23/2023, 4:40 AMCan you
UNION ALLAsher Densmore-Lynn
06/23/2023, 4:41 AMWait, never mind, that's not what you want.