This content has been marked as final. Show 1 reply
Each JOIN clause must contain an ON condition (except for CROSS JOIN but let's not go there) so your example isn't syntactically valid and I'm not sure what you are comparing to what. I would probably write it as:1 person found this helpful
The order in which you arrange the join clauses will not affect performance.
select * from from hrm2_requests req left join hrm2_request_complaints hrm_comp on hrm_comp.work_order = req.work_order left join hrm2_swap_complaint_detail comp_dtl on comp_dtl.complaint_detail_code = hrm_comp.complaint_detail_code left join hrm2_swap_complaint comp on comp.complaint_code = comp_dtl.complaint_code