• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
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