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 ...

Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro! Do you ever find yourself juggling queries to get the information you need?

Ok guys I'll admit this is homework but I've spent two days trying to figure out how to do this last query and I'm simply stumped. I'm pretty sure I know, intellectually how to do it but I can't ...