SELECT A.doc_no, A.product_catalog_code, A.qty AS qty_dwh_sales, A.harga_katalok AS harga_katalok_dwh_sales,
    A.subtotal_harga_katalok AS subtotal_harga_katalok_dwh_sales, A.diskon_member_amount AS diskon_member_amount_dwh_sales,
    A.subtotal_harga_member AS subtotal_harga_member_dwh_sales, A.fee_ds_amount AS fee_ds_amount_dwh_sales,
    A.discount_promo_amount AS disc_promo_amount_dwh_sales, A.subtotal_harga_nett AS subtotal_harga_nett_dwh_sales,
    B.jumlah_pesan AS jumlah_pesan_oldsys, B.jumlah AS jumlah_oldsys, B.harga_katalok_penjualan AS harga_katalok_penjualan_oldsys,
    B.diskon_member_penjualan AS diskon_member_penjualan_oldsys, B.diskon_promo_penjualan AS diskon_promo_penjualan_oldsys,
    B.harga_netto_penjualan AS harga_netto_penjualan_oldsys, B.total_harga_katalok AS total_harga_katalok_oldsys,
    B.total_diskon AS total_diskon_oldsys, B.total_harga_netto AS total_harga_netto_oldsys
FROM dwh_sales A
INNER JOIN copy_factpenjualanoldsys B ON A.doc_no = B.id_penjualan AND UPPER(TRIM(A.product_catalog_code)) = UPPER(TRIM(B.id_produk))
where STRING_YEAR = '2015';