USE [FullCrossJoin]
GO
/****** Object:  Table [dbo].[TableA]    Script Date: 11/11/2018 4:22:01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TableA](
	[ID] [int] NULL,
	[Name] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TableB]    Script Date: 11/11/2018 4:22:01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TableB](
	[ID] [int] NULL,
	[Name] [varchar](50) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[TableA] ([ID], [Name]) VALUES (1, N'Sam')
INSERT [dbo].[TableA] ([ID], [Name]) VALUES (2, N'Fred')
INSERT [dbo].[TableA] ([ID], [Name]) VALUES (3, N'Sally')
INSERT [dbo].[TableA] ([ID], [Name]) VALUES (4, N'Cindy')
INSERT [dbo].[TableA] ([ID], [Name]) VALUES (5, N'Sue')
INSERT [dbo].[TableB] ([ID], [Name]) VALUES (1, N'Fred')
INSERT [dbo].[TableB] ([ID], [Name]) VALUES (2, N'Sam')
INSERT [dbo].[TableB] ([ID], [Name]) VALUES (6, N'Sandy')
INSERT [dbo].[TableB] ([ID], [Name]) VALUES (7, N'Eric')
INSERT [dbo].[TableB] ([ID], [Name]) VALUES (8, N'Pat')