SQL - Using Sum(Column A) When Column B Contains 'ABC'
Using SQL... How do I sum Column A only when Column B contains specific text - such as 'ABC'? And then Sum Column A again if Column B contains 'XYZ', and so on and so forth.
Column A is the number -- Column B contains a wide variety of text descriptions that I want to "sum" over and over again and drop into different columns that I name myself.
Thank you,
Judy B.