Hello. I am creating queries to join data from various tables but the results i'm getting are different. Showing the individual queries below and what happens when i link them. Note that i have tried all the different join options and still get different data. Can anyone help?
1. Single table query - these results are correct
2. 2nd table query - these results are correct
SCODE First Of Data Partners Sum Of Budget DBMD Verve & Groundtruth $53,333.33 DBMV $26,666.67
$80,000.00
SCODE First Of Vendor Sum Of Cost to Client DBMD DBM 57,826.70 DBMV DBM 201,889.34 FB/IG Facebook/Instagram 239,575.61 GGLS Google Ads 72,747.43
572,039.08
3. Combined Query (joined where the SCODE column which is from a separate table links both tables and set up so that all of the SCODEs are supposed to be shown but only the matching table data should be included - #2 in the join options)
SCODE Sum Of Budget Sum Of Cost to Client DBMD $106,666.67 231,306.80 DBMV $106,666.67 201,889.34
$213,333.33 433,196.14