I have a fairly simple query that pulls in duplicated amounts that I want to remove.
SELECT
od.parentorganizationname
,cdc.CountyName
,ad.AllocationAmt
FROM (I've abbreviated the actual tables and joins)
odtable as od
cdctable as cdc
adtable as ad
Results look like this:
|parentorganizationname |CountyName| AllocationAmt |
|Provider A |Scotty| $68,168.29 |
|Provider B| Toner| $144,411.00 |
|Provider B |Booker| $144,411.00 |
|Provider B |Tracker| $144,411.00 |
|Provider B| GREENE| $144,411.00 |
|Provider B| GREENE| $144,411.00 |
|Provider B| GREENE| $144,411.00 |
|Provider B| MORGAN| $144,411.00 |
|Provider C| STE GENEVIEVE| $31,960.00 |
|Provider C| CAPE GIRARDEAU| $31,960.00 |
My goal is to set up the query so that the results do not show the duplicate Allocation Amounts.
In other words, Provider A would show their amount, Provider B would show the $144,411 amount but not keep repeating.
I hope this is sufficient info given for what I'm asking for.
Thank you for any and all help!!