DECLARE @incoming AS TABLE
(
CustID VARCHAR (50),
TDate VARCHAR (6),
Value DECIMAL (15, 2)
)
DECLARE @outgoing AS TABLE
(
CustID VARCHAR (50),
TDate VARCHAR (6),
Value DECIMAL (15, 2)
)
INSERT INTO @incoming
VALUES
(
'1', '201701', '10.24'
)
INSERT INTO @incoming
VALUES
(
'2', '201701', '35.66'
)
INSERT INTO @incoming
VALUES
(
'3', '201702', '19.55'
)
INSERT INTO @outgoing
VALUES
(
'3', '201701', '10.24'
)
INSERT INTO @outgoing
VALUES
(
'4', '201701', '35.66'
)
INSERT INTO @outgoing
VALUES
(
'5', '201702', '19.55'
)
SELECT * FROM @incoming
UNION ALL
SELECT * FROM @outgoing
The output I'm looking for is six columns, three from @incoming and three from @outgoing containing all records (irrespective of NULLs).
The common column in each table is CustID.
The output would be
1 201701 10.24 NULL NULL NULL
2 201701 35.66 NULL NULL NULL
3 201702 19.55 3 201701 10.24
NULL NULL NULL 4 201701 35.66
NULL NULL NULL 5 201702 19.55
Thanks in advance.