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
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.
it happend since there was no match!!!!
thank you so much