Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

wrong result with RIGHT JOIN. (how to have 2 right join in the same statement?)  RSS feed

 
Peter Primrose
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I wanted to add a new column to my sql statement:



but I recieve wrong result (the SUM(CSV_net.cur_amount) is 3 times higher)

the sql statement looks like this:



if I eliminate the first statement above the return result are fine.

am I right with the RIGHT JOIN?

thanks
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!