Dear brother I think to sum a field in the two tables, and compare whether equal but under the condition of the same two table join query results and the results of two tables query respectively different yeah ~ why is this?

CodePudding user response:

Put the bai code

CodePudding user response:

Look at the code,
I guess:
1, the presence of a one-to-many;
2, there are some empty value influence;
3, some carrying you changed data ha ha ha ha...

CodePudding user response:

reference 1st floor dangyb response:

code to stick the bai

thank there are one-to-many situation has been solved

CodePudding user response:

refer to the second floor yujiaxucheng response:

look at the code,
I guess:
1, the presence of a one-to-many;
2, there are some empty value influence;
3, some carrying you changed data ha ha ha ha...

ha ha ha ha thank you is the existence of one to many

CodePudding user response:

reference 4 floor liu_mang_tu response:

Quote: refer to the second floor yujiaxucheng response:

Look at the code,
I guess:
1, the presence of a one-to-many;
2, there are some empty value influence;
3, some carrying you changed data ha ha ha ha...

ha ha ha ha thank you is the existence of a one-to-many

Stick, it is good to solve the ~