When Developer is trying to Join the following line to the SQL it just doesn't work and no error message given. The developer has added 3 of the 4 joins and when he tries to add the 4th one it just "errors" out, again no error message given.
LEFT OUTER JOIN FA_CALENDAR_PERIODS fcp on fct.CALENDAR_TYPE = fcp.CALENDAR_TYPE
Any one know how to understand what is happening and why we are not getting a typical error message.