create table amc_systematic_summary asselectbroker_dealer_master.broker_code,broker_dealer_master.broker_name,branch_mis_master.mis_branch_code,branch_mis_master.mis_branch_name,branch_mis_master.mis_branch_city,branch_mis_master.mis_branch_cluster,branch_mis_master.mis_branch_region,branch_mis_master.mis_branch_state,branch_mis_master.mis_zone_name,branch_mis_master.mis_business_center,branch_emp_master.emp_branch_code,branch_emp_master.emp_branch_name,branch_emp_master.emp_branch_cluster,branch_emp_master.emp_branch_region,branch_emp_master.emp_zone_name,broker_dealer_classification_master.broker_dealer_classification,broker_dealer_group_master.broker_dealer_group,ae_master.ae_code,euin_master.euin_code,brh_master.brh_code,amc_branch_emp_hierarchy_relation_master.rm_code,amc_branch_emp_hierarchy_relation_master.emp_code,master_employee_details.emp_name,amc_investor_segment_master.inv_segment_name,amc_investor_segment_master.inv_segment_group_name,product_master.fund_name,product_master.scheme_name,product_master.scheme_code,product_master.sub_fund_code,product_master.scheme_nature,product_master.asset_class,product_master.asset_category,product_master.inception_date,product_master.average_maturity_date, amc_sales_summary.branch_location_classification,amc_sales_summary.tax_status_summary,amc_sales_summary.run_date,amc_sales_summary.aum,amc_sales_summary.wgt_aum,amc_sales_summary.aum_avg_age,amc_sales_summary.avg_age,amc_sales_summary.aum_0m_1m,amc_sales_summary.aum_1m_3m,amc_sales_summary.aum_3m_6m,amc_sales_summary.aum_6m_9m,amc_sales_summary.aum_9m_12m,amc_sales_summary.aum_12m_15m,amc_sales_summary.aum_15m_18m,amc_sales_summary.aum_18m_21m,amc_sales_summary.aum_21m_24m,amc_sales_summary.aum_24m_36m,amc_sales_summary.aum_36m_48m,amc_sales_summary.aum_48m_60m,amc_sales_summary.aum_above_60m,amc_sales_summary.avg_aum,amc_sales_summary.wgt_avg_aum,amc_sales_summary.transaction_count, getdate() load_datefrom ontology.public.amc_systematic_sales_summary amc_sales_summaryleft join ontology.public.product_master product_masteron amc_sales_summary.product_id=product_master.product_idleft join ontology.public.broker_dealer_master broker_dealer_masteron amc_sales_summary.broker_dealer_id = broker_dealer_master.broker_dealer_idleft join ontology.public.branch_mis_master branch_mis_masteron amc_sales_summary.branch_mis_id = branch_mis_master.branch_mis_idleft join ontology.public.branch_emp_master branch_emp_masteron amc_sales_summary.rm_id = branch_emp_master.rm_idleft join ontology.public.broker_dealer_classification_master broker_dealer_classification_masteron amc_sales_summary.broker_dealer_id = broker_dealer_classification_master.broker_dealer_idleft join ontology.public.broker_dealer_group_master broker_dealer_group_masteron amc_sales_summary.broker_dealer_id = broker_dealer_group_master.broker_dealer_idleft join ontology.public.amc_branch_emp_hierarchy_relation_master amc_branch_emp_hierarchy_relation_masteron amc_sales_summary.rm_id = amc_branch_emp_hierarchy_relation_master.rm_idleft join ontology.public.ae_master ae_masteron amc_sales_summary.ae_id = ae_master.ae_idleft join ontology.public.euin_master euin_masteron amc_sales_summary.euin_id = euin_master.euin_idleft join ontology.public.brh_master brh_masteron amc_sales_summary.brh_id = brh_master.brh_idleft join ontology.public.amc_investor_segment_master amc_investor_segment_masteron amc_sales_summary.inv_segment_id = amc_investor_segment_master.inv_segment_idleft join master_db.public.employee_details master_employee_detailson amc_branch_emp_hierarchy_relation_master.emp_code = master_employee_details.emp_code