AAAAAAA It works, Thanks a lotttt!

I have edited my last post to put the updated script. My desire is to have result like D the which is the last table on my first post. Thanks...

Here is my script to create the 3 tables, thanks a lot!!!!

USE [Sample]

GO

/****** Object: Table [dbo].[TableA] Script Date: 2/18/2015 6:49:35 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET...