https://community.developer.cybersource.com/t5/Integration-and-Testing/Fusing-two-queries/m-p/69719#M42691 <P class="_1qeIAgB0cPwnLhDF9XSiJM">So I'm having some trouble piecing together this Select query. My goal was to smash together the usefulness of a Duplicate-searching query (labelled exhibit A), with the usefulness of a Marking query (labelled exhibit B).</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">When I perform these queries separately, they work fine. However, when I try running it's fused counterpart it gives me an error "#1054 - Unknown column 'w.FName' in 'on clause'". I don't think I need a Union for what I'm doing. Could someone help me out with this?</P> Sat, 16 Nov 2019 14:15:12 GMT FarbinJones 2019-11-16T14:15:12Z https://community.developer.cybersource.com/t5/Integration-and-Testing/Fusing-two-queries/m-p/69719#M42691 <P class="_1qeIAgB0cPwnLhDF9XSiJM">So I'm having some trouble piecing together this Select query. My goal was to smash together the usefulness of a Duplicate-searching query (labelled exhibit A), with the usefulness of a Marking query (labelled exhibit B).</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">When I perform these queries separately, they work fine. However, when I try running it's fused counterpart it gives me an error "#1054 - Unknown column 'w.FName' in 'on clause'". I don't think I need a Union for what I'm doing. Could someone help me out with this?</P> Sat, 16 Nov 2019 14:15:12 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/Fusing-two-queries/m-p/69719#M42691 FarbinJones 2019-11-16T14:15:12Z