Make Table querys with SQL

  • Thread starter Thread starter Chris H
  • Start date Start date
C

Chris H

I am using acces to query a SQL 6.5 Server database. One
of the views I am querying opens 11 tables, and the query
I am trying to run, get stopped by the 16 table limit in
SQL 6.5. Would a make table query stop this, but only
making a table from this large SQL view with the fields I
need, and then using this with the other view for my
initial query?

Is this 16 table limit present in SQL 2000??

Rgrds
Chris
 
Chris

Another approach would be to create a view in SQL Server, pre-joining those
tables you need.

For questions about SQL Server specifications/limits, consider posting in
the SQL Server groups.
 
Back
Top