Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save trycf/946ffba52518d6602ad1e8b25618746a to your computer and use it in GitHub Desktop.
Save trycf/946ffba52518d6602ad1e8b25618746a to your computer and use it in GitHub Desktop.
TryCF Gist
<cfscript>
q1=queryNew('a,c')
q2=queryNew('b')
u=queryExecute("select * from q1 union select q2.* from q2, q1 where q1.a=q2.b",{},{dbtype:'query'})
</cfscript>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment