Hi, I have a table called deal_fact a and alias of the same deal_fact b.Now i want to achive the following query by joining two tables in impromptu.How should i join them. select count(a.deal_key) from deal_fact a, deal_fact b where (b.time_key (+)=20030629 ) and a.time_key=20030725 and a.deal_key=b.deal_key(+) Joining deal_fact a and deal_fact b and using outer join on deal fact a side will give me a.deal_key=b.deal_key(+) but what aboutb.time_key (+)=20030629 .How can I achieve that??what are other workarounds...is that possible using any other cognos tool...