SQL Union All Query

M8KWR · May 16, 2006

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 · May 16, 2006

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 · May 16, 2006

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 · May 16, 2006

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/

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

SQL Union All Query

M8KWR

Programmer

r937

Technical User

M8KWR

Programmer

SQLDenis

Programmer

Similar threads

Part and Inventory Search

Sponsor