SQL join subquery

Try to remove AS keywrod after FROM and JOIN subquery as below

SELECT S2.ITEM, S1.SHOP_ORDER, S1.OPERATION_NO, S1.START_DATE,S1.QTY_GOODS, S1.QTY_ENTERED, S1.QTY_MRBFROM (    SELECT SHOP_ORD_RPT.OPERATION_NO, SHOP_ORD_RPT.SHOP_ORDER    FROM FLAME.SHOP_ORD_RPT    WHERE SHOP_ORD_RPT.OPERATION_NO =110    OR SHOP_ORD_RPT.OPERATION_NO =370    )  S1JOIN (    SELECT SHOP_ORD.SHOP_ORDER    FROM FLAME.SHOP_ORD    WHERE SHOP_ORD.ITEM ='3A2375'    OR SHOP_ORD.ITEM ='3A2703'    )  S2ON S1.SHOP_ORDER = S2.SHOP_ORDER;

It is possible to put a subquery within the from clause. Try this:

SELECT S2.ITEM,       S1.SHOP_ORDER,       S1.OPERATION_NO,       S1.START_DATE,       S1.QTY_GOODS,       S1.QTY_ENTERED,       S1.QTY_MRBFROM   (SELECT SHOP_ORD_RPT.OPERATION_NO,               SHOP_ORD_RPT.SHOP_ORDER        FROM   FLAME.SHOP_ORD_RPT        WHERE  SHOP_ORD_RPT.OPERATION_NO = 110                OR SHOP_ORD_RPT.OPERATION_NO = 370) S1,      (SELECT SHOP_ORD.SHOP_ORDER       FROM   FLAME.SHOP_ORD       WHERE  SHOP_ORD.ITEM = '3A2375'               OR SHOP_ORD.ITEM = '3A2703') S2WHERE S1.SHOP_ORDER = S2.SHOP_ORDER;