@JustinH mentioned a querying/join requirement in 1:M Join to Pull feature with Specific Attribute information:
I pull all of the data from an AGOL Feature Service that our organization is hosting.
It took several awkward geoprocessing steps to achieve the required results. It would have been a lot more efficient to just write a simple SQL query with a LEFT JOIN.
