How to merge 3 tables by the field from 4th table

CREATE TABLE #Main
(
MainID int,
MainData varchar(50)
)
INSERT #Main VALUES(1,'main1')
INSERT #Main VALUES(2,'main2')
INSERT #Main VALUES(3,'main3')

CREATE TABLE #TabA
(
ID_A int,
ID_Main int,
Data_A varchar(50)
)
INSERT #TabA VALUES(1,2,'A2')
INSERT #TabA VALUES(2,3,'A3')

CREATE TABLE #TabB
(
ID_B int,
ID_Main int,
Data_B varchar(50)
)
INSERT #TabB VALUES(1,1,'B3')
INSERT #TabB VALUES(2,1,'B3_1')

CREATE TABLE #TabC
(
ID_C int,
ID_Main int,
Data_C varchar(50)
)
INSERT #TabC VALUES(1,3,'C3')

SELECT MainID,MainData,ISNULL(Data_A,'') AS Data_A,ISNULL(Data_B,'') AS Data_B,ISNULL(Data_C,'') AS Data_C
FROM #Main M
LEFT JOIN #TabA A ON M.MainID = A.ID_Main
LEFT JOIN #TabB B ON M.MainID = B.ID_Main
LEFT JOIN #TabC C ON M.MainID = C.ID_Main

DROP TABLE #Main
Drop Table #TabA
Drop Table #TabB
Drop Table #TabC

try this

Thanks,

Imrana