I'm just wondering if this is even possible: I'm building a query program for our users. There are 5 tables that they could gather various pieces of data from, and I'm wondering if there is a "FROM" statement that I can just tack on that will gather whatever data they input, so I don't have to worry about building custom FROM statements. I've tried a variety of combinations with INNER JOINS, but if I include more than 2 tables, it doesn't return anything.

Any ideas?

edit: Using SQL Server 2K, by the way.