SQL Join

[FMRock]

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.

[Grizzly]

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

[FMRock]

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

[ksuohio]

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

Smart man!

[OS-Wiz]

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