If I make a view that contains 1 view and 1 table, I can get done exactly what I need done. However, I don't really want to make a ton of subviews, and would like to be able to type it all into one SQL view.

However, so far everything I've tried doesn't seem to work, and so I ask: What is the syntax in a SQL statement that contains a subquery inside it? Would I be seing a "FROM" and "SELECT" inside this subquery at all?

Thanks,
Dustin