Jump to content
Changes to the Jaspersoft community edition download ×

inner join operation for fetching data from multiple tables is not working fine in Jaspersoft studio


email.vinu04

Recommended Posts

The query which I have written for fetching data from 3 tables is working fine in SQL server management studio and MS Access but in Jaspersoft studio it is giving unexpected output with many duplicate records. My query looks something like this

Employee table:  emp_Id, emp_name, salary, Dep_num, project_id  --->Primary key=emp_Id

Department table: Dep_num, Dep_name, Manager                     ----->Primary key= Dep_num

Project table: project_id, project_name, project_loc            ------->Primary key=project_id

I want to have a resul table like  emp_name, Dep_name,project_name

I have written query like this

select emp_name, Dep_name, project_name

from Employee as E  inner join Department as D on E.Dep_num = D.Dep_num

inner join Project as P on E.project_id = P.project.id;

so I am awaiting any response from jasper team, query is fine but jasper is not giving correct output, anyone help me out, how to deal with this issue

 

 

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

  • 2 years later...

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