Get sum of one column based on another column of other table.

[drogo96]

I have to calculate the sum of the amount of the transaction table which has columns of distinct phones, dates and amounts. These numbers are also included in the Users table which has columns for unique phone, date and is_mobile. Is_mobile may have 0 or 1 value.

for a better understanding of my question, I am mentioning the MySQL query

Select count(phone) from transaction where date(dateCreated)>='2022-10-10' and date(dateCreated)<='2022-10-31' and phone IN(Select phone from users where is_mobile=0)

[watkinnc]

= List.Sum(TableName[amounts])

--Nate