Hi All,
I am trying to join more than two tables for brit report. I am using eclipse designer IDE.
Anybody please let me know any suggestion or step procedure for joining complex queries.
Regards,
Basudeba
Page 1 of 1
Not able to Join more than two tables in brit.
in case simple query, i am able to get the results in the report.
Rate Topic:
MultiQuote
#2
averma 
- Senior Member
-
- Group: Administrators
- Posts: 713
- Joined: 08-August 07
Posted 14 March 2012 - 09:33 AM
Hi Basudeba,
There are several ways you can do this. If these tables are from the same data source, you could write a SQL statement that merges(joins) the data at the database layer. If you do a web searh on "SQL join" you will find several examples.
Using BIRT you can also join data from disparate data source. This would involve first defining the data sets from different sources and then creating another joint data set and specify the join type (inner, outer etc...). Here is an example of the latter approach:
http://www.birt-exch...join-data-sets/
There are several ways you can do this. If these tables are from the same data source, you could write a SQL statement that merges(joins) the data at the database layer. If you do a web searh on "SQL join" you will find several examples.
Using BIRT you can also join data from disparate data source. This would involve first defining the data sets from different sources and then creating another joint data set and specify the join type (inner, outer etc...). Here is an example of the latter approach:
http://www.birt-exch...join-data-sets/
Page 1 of 1
