How to JOIN
Today I am writing a little blog about SQL joins First we have to create two tables and insert some very simple data for testing. CREATE TABLE [dbo].[TableLeft]([Key] [varchar](50) NULL, [LeftValue] [varchar](50) NULL) CREATE TABLE [dbo].[TableRight]([Key] [varchar](50) NULL, [RightValue] [varchar](50) NULL) INSERT [dbo].[TableLeft] ([Key], [LeftValue]) VALUES (N'3', N'LeftValue_1') INSERT [dbo].[TableLeft] ([Key], [LeftValue]) VALUES (N'1', [...]