Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Need help with comparinmg 2 columns

Hi there,   I have two table A and B. Now i would like to sum up the Spend for all parts in Table B with a particular colour provided the parts are present in Table A. Table A Supplier, Part ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

selimovd

Thanks for responding.Yes it is a one to many model and i somehow managed it.I used the in operator to see if the part in B is in A.

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

If it's a one to many relationship you shouldn't have a problem.

Then one supplier has also has only one part. Then you can just pull all the columns in a table and get the result.

 

Or where are you struggling?

 

Otherwise please provide the tables, picture of the relationship and the desired result.

We want to help you, but you have to give the information...