So I have two huge linked tables, and I want to conduct a fairly complex query on them. I've managed to extract the data I need, but my process uses multiple sub queries and it's just too slow for my DB users.
Table 2 shows Facility ID, fluid type, fluid amount, and reporting date (as year and...