16 tables limit

greenspun.com : LUSENET : SQL Server Database Administration : One Thread


I was wondering if this is a bug in SQL Server6.5. I run a query from my PeopleSoft application and I get this error . It says:

"SQL error. Stmt #: 4192 Error Position: 0 Return: 8601 - [Micosoft] [ODBC SQL Server Driver][SQL Server] The query and the views in it exceed the limit of 16 tables. (SQLSTATE S1000) 4408"

If this is a bug, is there any patchwork or a workaround? Please advice. Thank you for your time. Praveer

-- Anonymous, December 14, 1998


Re: 16 tables limit


The best thing to do in this case is to use temporary intermediate tables. If you look at the SELECT statement grammar in Books Online, it accepts a maximum of 16 tables.


-- Anonymous, December 15, 1998

Moderation questions? read the FAQ