Re: Using Joins

2006-04-19 Thread Ted Schrader
record one master record is returned. From: Ted Schrader [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 18, 2006 8:34 PM To: user-java@ibatis.apache.org Subject: Re: Using Joins   Hi Suresh, Give us the select statement you have right now so we can see. In the meantime, try: SELE

RE: Using Joins

2006-04-18 Thread suresh.dodda
contains resultMap2 as a list, but for every detail record one master record is returned. From: Ted Schrader [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 18, 2006 8:34 PM To: user-java@ibatis.apache.org Subject: Re: Using Joins   Hi Suresh, Give us the select statement you have right

Re: Using Joins

2006-04-18 Thread Ted Schrader
Hi Suresh,Give us the select statement you have right now so we can see. In the meantime, try: SELECT *  FROM Employee e INNER JOIN    Dept d ON e.empId = d.empId TedOn 18/04/06, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote:> >>   > > I am trying find the results from the multiple t

Using Joins

2006-04-18 Thread suresh.dodda
I am trying find the results from the multiple tables.   I have Employee table with empId and empname.  Dept table with empId and deptno, dept-name There are only two rows in master and two corresponding rows in the detail tables.   When I am using the Inner join I am getting the four