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.