Query Of Queries : Error When Trying To Fake Left Outer Join

Hi there

I am trying to replicate a left outer join, combining two query of queries using a method I located here

However, I keep getting an error message..

Here is the code I am using....

    <cfquery dbtype="query" name="qry">
                SELECT *
                FROM returnQry, returnQry2
                WHERE returnQry.mediumImage = returnQry2.mediumImage
                ORDER BY returnQry.name   
            </cfquery>
                       
            <cfquery name="returnQry3" dbtype="#application.mx#">
                SELECT *
                FROM trackmeanings AS t
            </cfquery>      

           <cfquery dbtype="query" name="endQry">
                SELECT name,nameRcd,mediumImage, COUNT(sMessage) AS comments
                FROM qry, returnQry3
                WHERE qry.name = returnQry3.sNameTrack
                               
                UNION
               
                SELECT name,nameRcd,mediumImage, COUNT(sMessage) AS comments
                FROM qry, returnQry3
                WHERE #qry.name# NOT IN (#QuotedValueList(returnQry3.sNameTrack)#)
                GROUP BY name,nameRcd,mediumImage
            </cfquery>

When I try to use the query output in a page, i get the error message "Incorrect conditional expression,  Expected one of [like|null|between|in|comparison] condition"

Would anyone have any ideas?

Many thanks