Hi friends, I would like to request help for this problem. I have this SQL statements below. If I jus insert 1 JOIN staments it works but now I have two JOIN and it doesn't works. It show errors missing keyword. Pls give me a hand. Thanks
strSQL = "SELECT PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.LOT,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.TRANSCODE,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.TIME_STAMP, " & _
        "PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.OWNER,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.OPERATION,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.PRODUCT," & _
        "PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.PRODUCT_TYPE,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.PROCESS_GROUP, " & _
        "PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.PROCESS_CLASS,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.ROUTE, " & _
        "PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.MEAS_STEP,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.BASIC_TYPE, " & _
        "PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.""OPERATOR"",PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.EQUIPMENT, " & _
        "PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.TRANSACTION_COMMENT,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.QTY_IN_1,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.QTY_OUT_1 " & _
        "FROM PS_DWH_ADMIN.DWH_WIP_DATA_YEAR " & _
        "JOIN PS_DWH_ADMIN.DWH_WIP_EDC_DATA_YEAR " & _
        "ON PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.OPERATION = PS_DWH_ADMIN.DWH_WIP_EDC_DATA_YEAR.OPERATION " & _
        "AND  PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.FACILITY = PS_DWH_ADMIN.DWH_WIP_EDC_DATA_YEAR.FACILITY " & _
        "AND PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.LOT = PS_DWH_ADMIN.DWH_WIP_EDC_DATA_YEAR.LOT " & _
        "JOIN PS_DWH_ADMIN.DWH_WIP_EDC_VALUES_YEAR" & _
        "ON PS_DWH_ADMIN.DWH_WIP_EDC_DATA_YEAR.PARAMETER_SEQUENCE_NUMBER = PS_DWH_ADMIN.DWH_WIP_EDC_VALUES_YEAR.PARAMETER_SEQUENCE_NUMBER"
 strSQL = strSQL & "WHERE(PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.TIME_STAMP)>to_date('1/4/2013', 'dd/mm/yyyy') " & _
        "AND (PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.FACILITY)='TDH2MS' " & _
        "AND (PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.TRANSCODE)='MVOU' " & _
        "AND (PS_DWH_ADMIN.DWH_WIP_EDC_DATA_YEAR.PARAMETER_NAME)='KELVIN-LOSS' " & _
        "GROUP BY PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.LOT,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.TRANSCODE,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.TIME_STAMP,  " & _
        "PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.OWNER,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.OPERATION,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.PRODUCT, " & _
        "PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.PRODUCT_TYPE,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.PROCESS_GROUP, " & _
        "PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.PROCESS_CLASS,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.ROUTE, " & _
         "PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.MEAS_STEP,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.BASIC_TYPE, " & _
        "PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.""OPERATOR"",PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.EQUIPMENT, " & _
        "PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.TRANSACTION_COMMENT,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.QTY_IN_1,PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.QTY_OUT_1"