If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

one weird problem!!!values show as 0 after the join!!!

Started by katdbc, 07 Oct 2010 11:41:58 AM

Previous topic - Next topic

katdbc

i have a value called 'total payment" in one of the table,when i make an inner join with another table the resultant query shows the values of'total amount' as 0.I dont know why!!!any suggetsions

cognostechie

An Inner join will filter data from a table if the related record does not exist in another table. Maybe that's why it is showing the Total as 0. Try to see the detailed data to determine what's going on.

It is best to understand how the data is structured in the tables to understand whether you need to create an inner join or outer.

katdbc

it happend since there was no match!!!!
thank you so much