is join query possible with jasper?

[2005 IR Help]

By: Ronak - gandugamerio

is join query possible with jasper?

2004-06-16 08:02

Hi i m just wandering that join query possible or not with jasper.

 

Select A.UserName ,A.UserPassword,B.City,B.Zipcode from User as A, Address as B where A.userid = B.userid and a.userid =1

 

so , basicaly i need username,userpassword from one table and city,zipcode from different table .is this possible or i need to make subreport for that.

 

if its possible then please let me know what is name and value for each feild.

 

 

Thanks.