500 Tables Join as Single Table

[Franklin]

Hi,
I'm having 500 tables in my database. Some tables having same feilds some tables having different feilds i want to join all 500 tables into one table
I hope that u going to give the answer


Thank U.............

[Evilferret]

Why do you need so many tables?
And why are there tables that have the same fields?
Can you merge any of them together?

Normally I'd say just do a normal join, but with 500+ tables you'll probably run into memory issues.

Can you upload a copy of the database so I can get a better idea of why you're using so many tables?

[ssanfu]

Sure sounds like a normalization issue.....