CREATE VIEW V_Or_Manager AS (
    SELECT
        resMember.strnama_dealer,
        resMember.strkode_dealer,
        resMember.strnama_upline,
        resOmsetUnit.intid_dealer,
        resCabang.strnama_cabang,
        resUnit.strnama_unit,
        resOmsetUnit.intid_unit,
        resOmsetUnit.intid_jpenjualan,
        resOmsetUnit.inttotal_omset,
        resOmsetUnit.intid_week,
        resOmsetUnit.datetgl
    FROM
        (
            SELECT
                a.intid_cabang,
                a.intid_dealer,
                a.intid_unit,
                a.intid_jpenjualan,
                a.inttotal_omset,
                a.intid_week,
                a.datetgl
            FROM
                nota a,
                unit b
            WHERE
                a.intid_unit = b.intid_unit
            AND a.is_dp = 0
            GROUP BY
                a.intid_unit,
                b.intid_unit,
                a.intid_week
        ) resOmsetUnit
    LEFT JOIN (
        SELECT
            strnama_dealer,
            strkode_dealer,
            strnama_upline,
            intid_dealer
        FROM
            member
    ) resMember ON resMember.intid_dealer = resOmsetUnit.intid_dealer
    LEFT JOIN (
        SELECT
            intid_unit,
            strnama_unit
        FROM
            unit
    ) resUnit ON resUnit.intid_unit = resOmsetUnit.intid_unit
    LEFT JOIN (
        SELECT
            intid_cabang,
            strnama_cabang
        FROM
            cabang
    ) resCabang ON resCabang.intid_cabang = resOmsetUnit.intid_cabang
    GROUP BY
        resMember.strnama_dealer,
        resMember.strkode_dealer,
        resMember.strnama_upline,
        resMember.intid_dealer
    ORDER BY
        resCabang.strnama_cabang ASC
)




[Err] 1349 - View's SELECT contains a subquery in the FROM clause