<select id="getMyElement" resultMap="myMap">
  select col1, col2
<isEqual property="PropertyId" compareValue="MyValue%">
      from table 1
</isEqual>
      from table 2
</select>