need [State Name] from the states table here

USE [NPA]

GO

/****** Object: Table [dbo].[States] Script Date: 02/05/2010 16:35:49 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[States](

[State Code] [nvarchar](3) COLLATE...