I've written the following query to find the charge by procedure for the current month, previous month, and fiscal year. The query works find until I try to join a new table (Rendering AS r ON r.[Rendering ID] = c.[Rendering Id]) so that I can pull in the name of the Rendering Provider. When I...