Get complete data from another table
I have 2 views
The main view contains most of the fields I need in my report but it has Field-A which contains only a portion of the total value I need for this field, the complete information I need for Field-A is in the 2nd view.
When I look at this field directly on the second view I get a number like 80K, but when I do a join with inner, outter or other type to get the same 80K number I need, I never get this number.
Which would be the way to get this number correct for this field in View1?