I am trying to get a Query Table to run with multiple Joins. Its fine for up to 3 joins but when I put the 4th one in it times out.
SELECT opportunity_type,opportunities.deleted as opp_deleted,opportunities.description as opp_desc,
sales_stage,opportunities.assigned_user_id as opps_assigned_userid,amount,user_name,cost_amount_c,actual_close_date_c,contract_line_c,
curr_prov_c,reptowho_c,nextsteps_c,probability,deal_stage_c,inf_dec_c,nomfd_dev_c,softapp_c,
end_user_c,machinesprodsoft_c,noofprint_c,useav_c,creditcleared_c,financeco_c,mpscontract_c,
printroom_c,wideform_c,account_id,accounts.name as Acc_Name,date_closed from opportunities
JOIN users ON opportunities.assigned_user_id = users.id
JOIN opportunities_cstm ON opportunities.id=opportunities_cstm.id_c
JOIN accounts_opportunities ON opportunities.id= accounts_opportunities.opportunity_id
JOIN accounts on accounts_opportunities.account_id = accounts.id