SQL Join

Im trying to join to identical tables, that say have 2 differnt states data. Because of the way the data is imported they cant be in one table. So I would like to make a view that has all the data in it. We are using a SQL Server 2000, and im sure this isnt that hard to do. Any help would be greatful.

Are you familiar with the UNION operator? That would be one way to attack it.

Ahh.. ill check that out. I have used that once or twice before but forgot about it. Ill google it and try it.

Thanks Griz

Quote:

---

Originally posted by Grizzly
Are you familiar with the UNION operator? That would be one way to attack it.

---

Smart man!

SELECT COL1, COL2, ...
FROM TAB1
UNION ALL
SELECT COL1, COL2, ...
FROM TAB2