SQL Union All Query

[M8KWR]

Is there a limit to the number of database with an sql database that you are able to use within a Union All type view query???

What i am trying to do is join about 80ish tables within into 1 view so i can query on this view as a whole in many different way.

I only need to bring over about 6 fields from this specific table.

Many thanks for any assistance in advance.

 

[r937]

if there is a limit, it depends on which database you're using

there's no limit in ANSI SQL, you could theoretically union as many tables as you wish

r937.com | rudy.ca

 

[M8KWR]

For example i used access to union select tables together and that has a limit (says query to complex), then what i did was to create multiple query and then union then ll together within another query....

Would this work within a view with SQL enterprise manager.

I'm assuming it will, but just want to check before i write all the sql coding.....

Many thanks

 

[SQLDenis]

Limit is 256 tables (from memory, but I am 99.9999% sure)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/