Hi Team ,
I am trying to join 3 table i have extract data from my sql
Its taking so much time not getting the result .
Please find the code below.
Please help how to reduce less time
code:
select
a.Month as DateField,
a.Engagement_Code,
a.Project_Name,
c.resource_display_name,
a.Project_StartDate,
a.Project_EndDate,
a.Project_Code,
a.Contract_Type,
a.Project_Manager,
a.Project_Work_Location_State,
a.Payment_Terms,
a.Project_Stage,
a.System_Revenue_Recognized,
a.Consolidated_All_Resource_Direct_Cost,
a.Consolidated_Other_Direct_Cost,
a.System_Revenue,
a.Plan_Utilization_Basis_Hours,
a.Actual_Utilized_Hours,
a.Actual_Projected,
b.Engagement_Name,
b.Engagement_Account_Executive,
b.Client_Name
From mis_automation_db.project_details_ppm a
Inner join mis_automation_db.engagement_project_summary_ppm b
on a.Engagement_Code = b.Engagement_Code
Inner join mis_automation_db.project_resource_details_ppm c
on a.Project_Code=c.Project_Code;
