CREATE TABLE [dbo].[Zip](
	[City_Cd] [varchar](100) NULL,
	[Zip_Cd] [varchar](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Zip] ([City_Cd], [Zip_Cd]) VALUES (N'Mobile', N'36601')
INSERT [dbo].[Zip] ([City_Cd], [Zip_Cd]) VALUES (N'New Orleans', N'70121')
INSERT [dbo].[Zip] ([City_Cd], [Zip_Cd]) VALUES (N'Luling', N'70070')
/****** Object:  Table [dbo].[State]    Script Date: 12/26/2012 19:01:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[State](
	[State_Cd] [char](2) NULL,
	[Descr] [varchar](150) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[State] ([State_Cd], [Descr]) VALUES (N'AL', N'Alabama')
INSERT [dbo].[State] ([State_Cd], [Descr]) VALUES (N'LA', N'Louisiana')
/****** Object:  Table [dbo].[City]    Script Date: 12/26/2012 19:01:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[City](
	[State_Cd] [char](2) NULL,
	[City_Cd] [varchar](100) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[City] ([State_Cd], [City_Cd]) VALUES (N'AL', N'Mobile')
INSERT [dbo].[City] ([State_Cd], [City_Cd]) VALUES (N'LA', N'New Orleans')
INSERT [dbo].[City] ([State_Cd], [City_Cd]) VALUES (N'LA', N'Luling')

SELECT s.[Descr],c.City_Cd
FROM dbo.[State] s
INNER JOIN dbo.[City] c    ON s.[State_Cd] = c.[State_Cd]

CREATE NONCLUSTERED INDEX [IX_State_State_Cd_001] ON [dbo].[State] 
(
	[State_Cd] ASC
)
INCLUDE ( [Descr]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]


CREATE NONCLUSTERED INDEX [IX_City_State_Cd_001] ON [dbo].[City] 
(
	[State_Cd] ASC
)
INCLUDE ( [City_Cd]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

We walk in the dark places no others will enter
We stand on the bridge and no one may pass