An alternative - again, if supported - would be to create a view that works the same as the derived table, and use this in your query instead.

A few strategic decisions can help improve your generative AI code and queries, and prevent sending out sensitive data.

I have a feeling that I should be able to write a single query to handle this, but I just can't think of how... Basically, I have two tables: "distributors" and "postalcodes".

Data comes from all kinds of sources and Microsoft Power Query can you when you need to combine foreign data. It’s a bit easier than trying to do so in Microsoft Excel sometimes.