Jasper & join 2 table query

[logudotcom]

In Jasper Report I had to take values from two tables with two quesries.But these two queries are releted one another

 

for example

 

Table 1: School, School Id, School Name

 

Table 2: Student, Student Id, Student Name, School Id

 

Now I need to report Like this,

 

School Name Student Names

 

St. Thomas's School - Ram Prasad

St. Paul's School - Vinoth Xavier

St. Mullers School - Loganathan, loguKK

 

How to take report in jasper or How to write query in jasper.

[tarelr]

I think, your topic is not in the right place, cause it is a SQL problem and is not a jasper issue.

 

For information,see the query:

 

Code:

select table1.schoolName,table2.studentName
from table1,table2
where --the joins clause
table1.schoolId=table2.schoolId