Dustin,

Please read about parameterized views. These are designed to select a few records based on some value supplied by the user or related to the parent record. Post back if this doesn't do what you need.


>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