ChrisM@Work (1/11/2013)
Why do you need to join to the other tables if they aren't contributing to the query, either as output or as a filter?
This is because of the following requirement:
Calculate the SUM of NCV_BL.TEU where NCV_BL.POL_LOCATION_CD or NCV_BL.POD_LOCATION_CD is not present in MG_VSLVOY_SCHEDULE.PORT_CD for the SAISAN_VESSEL_CD, SAISAN_VOYAGE_CD and SAISAN_LEG_CD in NCV_BL.
It would have been simpler otherwise.