Jump to content
Changes to the Jaspersoft community edition download ×

is join query possible with jasper?


2005 IR Help

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...