I'm starting another project and I'm currently designing our schema. I've got a couple many-to-many joins. I was wondering if a nested table is a better solution than simply creating an intersection ...

Basically anything in SQL can be replaced with a query. This includes tables, conditions, and even values. What is the mass of the average species at the site? So, we want to first determine the ...