MySQl - Need to accuire exact data by comparing 2 tables

Transact-SQL
1

hi Team,

I need your help in finding a solution for below issue,

i have a scenario where i have to compare 2 tables derive the status,

table 1 :
ID value
1 650

table 2
ID Value
1 50
1 75
1 60
1 450
1 200

here i need to compare the value of 2 table with the ID number to get the value of 650.

Scenario 1: I may get as exact match in table 2 as 650
Scenario 2:i may get exact match in table 2 by summing all the line as 650
Scenario 3:I may get the exact match in table 2 by summing any of the line corresponding to ID 1
here in the above scenario
i need to sum 1st,4th and 5th line to get exact match as 650.

i want help in deriving the 3rd scenario in MYSQL.

2

what have you tried?

3

What is the real-world purpose of this? It would have to examine a combinatorial explosion of possibilities.

1 Like
4

the purpose is this scenario is use for finding the accruals for the Shipment based on the cost estimates available in the table 2.

5

Sorry!! Mike01 im totally stucked with this.