Skip to Content
0
Former Member
Aug 29, 2008 at 07:44 AM

JOIN two the same table

12 Views

Dear Sir,

I have one fact table which record every year's finance data, example, total revenue and collect date

I want to compare two or three or ... year's data in one table.

If I use SQL, I will join the table column year and set alias name.

select a.total_revenue, b.total_revenue

from fct_fi a, fct_fi b

where a.year = (b.year + 1) and a.item = b.item

But In Business Object Desktop Intelligent, I only can build up two query, but I don't know how to let the two query produce releationship like the SQL descript.

Can any one help?

New in Business object