We are using a groupBy in our query for a report. In this query there is a union. The union is for two different tables and there is a possibility of a collision of the dispensingId that we are grouping on. So we could have dispensingId from table one of 50001 and a dispensingId of 50001 from table two. These shouldn't be grouped together. Will iBatis account for this? And if not is there a remedy for this?
<resultMap class="RxReportDataRow" groupBy="dispensingId" extends="rxReportDataRow" id="rxReportDataRowSigDisp"> Thanks, Tom
