Hi vishalkal,
Please refer below sample.
Use Union and Union All for add two table data.
SQL
DECLARE @Test1 AS TABLE (DATE VARCHAR(20),Nameofparty VARCHAR(100), Amount VARCHAR(20), Remark VARCHAR(10))
INSERT INTO @Test1 VALUES('2017-12-18 00:00:00','Dipesh Engg.','1854189','')
DECLARE @Test2 AS TABLE (DATE VARCHAR(20),Nameofparty VARCHAR(100), Amount VARCHAR(20), Remark VARCHAR(10))
INSERT INTO @Test2 VALUES('2018-03-12 00:00:00','Dipesh Engg.','598509.1','')
INSERT INTO @Test2 VALUES('2018-03-17 00:00:00','Dipesh Engg.','591501.3','')
INSERT INTO @Test2 VALUES('2018-02-03 00:00:00','Dipesh Engg.','378585','')
DECLARE @Test3 AS TABLE (DATE VARCHAR(20),Nameofparty VARCHAR(100), Amount VARCHAR(20), Remark VARCHAR(10))
INSERT INTO @Test3 VALUES('2018-01-24 00:00:00','Star Rewinders & Electricals','207500','')
INSERT INTO @Test3 VALUES('2018-04-05 00:00:00','Tirupati Enterprises','60300','')
INSERT INTO @Test3 VALUES('2018-05-16 00:00:00','Tirupati Enterprises','446220','')
-- UNION ALL does not remove dulicate.
SELECT * FROM @Test1
UNION ALL
SELECT * FROM @Test2
UNION ALL
SELECT * FROM @Test3
-- Removes dulicate if use UNION
SELECT * FROM @Test1
UNION
SELECT * FROM @Test2
UNION
SELECT * FROM @Test3
