SAP HANA query using joins

Hi friends

How to join more than 2 tables using sql hana query. while executing the below query am getting error.

first 2 joins are working fine while linking with join 3 error showing. How to achieve this query. Highlighted bold lines having the problem

BEGIN

OUT1 = SELECT ARTICLE_ID, COLOR_CODE, AMOUNT_SOLD FROM "vinoth"."SHOP_FACTS";

OUT2 = SELECT ARTICLE_ID,CATEGORY,SALE_PRICE,FAMILY_NAME FROM "vinoth"."ARTICLE_LOOKUP";

JOIN1 = SELECT T1.ARTICLE_ID, T1.COLOR_CODE, T1.AMOUNT_SOLD,T2.CATEGORY,T2.SALE_PRICE,T2.FAMILY_NAME

FROM

:OUT1 AS T1

LEFT OUTER JOIN

:OUT2 AS T2

ON

T1.ARTICLE_ID = T2.ARTICLE_ID;

var_out = SELECT ARTICLE_ID,CATEGORY,SALE_PRICE,COLOR_CODE,AMOUNT_SOLD,FAMILY_NAME FROM :JOIN1;

OUT3 = SELECT ARTICLE_ID,COLOR_CODE,CATEGORY,FAMILY_CODE FROM "vinoth"."ARTICLE_COLOR_LOOKUP";

JOIN2 = SELECT T3.ARTICLE_ID,T3.COLOR_CODE,T3.CATEGORY,T3.FAMILY_CODE

FROM

:JOIN1 AS T3

LEFT OUTER JOIN

:OUT3 AS X

ON

T3.ARTICLE_ID=X.ARTICLE_ID

var_out = SELECT ARTICLE_ID, COLOR_CODE,CATEGORY,FAMILY_CODE

END

Thanks

Vinoth