Would it be best to make the groupBy use two values one of the id and one of the type? We can make the groupBy use two values correct?
Thanks, Tom -----Original Message----- From: Nathan Maves [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 10, 2007 3:26 PM To: [email protected] Subject: Re: Group By and a Union, possible collision. I would assume that it will not handle it in the way you would like. How could it expect to know the difference. They in-fact have the same id I could be wrong, so don't take my word for it. Nathan On 4/10/07, Tom Henricksen <[EMAIL PROTECTED]> wrote: 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
