Just USE theTable ALIAS theAlias
then create the view to reference theAlias. Each table will be opened using the same alias.
>I would like to create one view to access multiple tables with the same structure. The only difference in these tables is the last two characters of the name.
>
>Thanks in advance
>
>Jeff Hibbs
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer