Quote:
>One of our developer is using a query which uses more than 16
>tables(some are views). He get a error message that the max limit of 16
>table exceeded. Does anyone ran into this problem ?
>-Guna
16 is really the max, and you can not use views of views to beat the limit.
You can use temporary tables within SQL Server, or if you are using Access, you
can define lower level views using <= 16 tables in SQL Server, and then define
Access queries joining SQL Server views. It's not pretty, but it works for me.
Tony Scandora, Argonne National Lab, 630-252-7541