CREATE TABLE #tmpa(ib int,  ia1 int)
CREATE TABLE #tmpb(ic int,  ib1 int)

INSERT INTO #tmpa (ib, ia1) VALUES (1,1)
INSERT INTO #tmpa (ib, ia1) VALUES (2,2)
INSERT INTO #tmpa (ib, ia1) VALUES (3,3)

INSERT INTO #tmpb (ic, ib1) VALUES (1,1)
INSERT INTO #tmpb (ic, ib1) VALUES (2,2)
INSERT INTO #tmpb (ic, ib1) VALUES (3,3)


SELECT * FROM #tmpa
LEFT JOIN #tmpb AS b_1 ON #tmpa.ib = b_1.ib1
LEFT JOIN #tmpb AS c_1 ON #tmpa.ib = b_1.ib1


SELECT * FROM #tmpa
LEFT JOIN #tmpb AS b_1 ON #tmpa.ib = b_1.ib1
LEFT JOIN #tmpb AS c_1 ON #tmpa.ib = c_1.ib1