I have A table 20 fields, B table 8 fields,
Between them in the same field ids (not a foreign key, can not link), and money,

Such as A table with 10 records, B table has 20 records, these records is filtered by A specific condition,
Article 1, 5 A and B are among those data, this article 5 data together, add up the money,
2, A form of alone don't do any operation, direct recording,
3, B form only need to link A table corresponding to the same article (certainly not 5) filled with the data, if A table without correlation C table data is populated,

How do you write the SQL???????

CodePudding user response:

What is C table?
Put your table fields, table name and post data, it is good to want what kind of result data also posted write SQL

CodePudding user response:

Table structure, the test data, the expected results, merging rules, all say once

CodePudding user response:

Junction post rate: 8.33%,,,,