Re: iBATIS - Joins ?

[Larry Meadors]

<select id="blah" resultClass="hashmap">

select a.versionnumber, a.releasedate, a.releasenotes, b.releasetype

from versioninfo as a, releaseinfo as b

where a.productid = #value# and a.releaseid = b.releaseid;

</select>

Map m = (Map)queryForObject("blah", 1);

Larry

On 9/21/06, Pradheep < [EMAIL PROTECTED]> wrote:

hey

 

can anyone let me know how to work on joins in iBATIS.

 

this is the query i am goin to use.

 

select a.versionnumber, a.releasedate, a.releasenotes, b.releasetype

from versioninfo as a, releaseinfo as b

where a.productid = 1 and a.releaseid = b.releaseid;

 

C ya

P R A D H E E P	A P P L I E D    D E V E L O P M E N T
Team Leader Chennai, India e: [EMAIL PROTECTED]  l: 00 91 44 39125333 m: 00 91 94862 08089

Pleasure in the job puts perfection in the work - Aristotle