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
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
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
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