troubleshooting Question

Need help determining cause of "FROM keyword not found where expected"

Avatar of maximus1974
maximus1974 asked on
Microsoft SQL Server* PL/SQLSQL* oracle syntax
6 Comments1 Solution70 ViewsLast Modified:
Need help determining why I keep getting "FROM keyword not found where expected" when i run the following in Oracle SQL Developer. Runs fine in Microsoft SQL Server. I know oracle uses PL\SQL but cannot find the culprit.

SELECT        BA_VIEW_SHIPPING_ORDERS.SM_NUMBER, BA_VIEW_SHIPPING_ORDERS.STATUS AS SM_STATUS, BA_VIEW_SHIPPING_ORDERS.ORDER_TYPE, 
                         BA_VIEW_SHIPPING_ORDERS.ORDER_NUMBER, DEPARTMENT.DEPT_NAME, BA_VIEW_SHIPPING_ORDERS.PN, 
                         BA_VIEW_SHIPPING_ORDERS.DESCRIPTION, BA_VIEW_SHIPPING_ORDERS.SHIP_NAME AS CUSTOMER_NAME, 
                         BA_VIEW_SHIPPING_ORDERS.SHIP_VIA_CODE, (CASE WHEN BA_VIEW_WO_SUMMARY.CONTRACT_TAT IS NULL 
                         THEN 21 ELSE BA_VIEW_WO_SUMMARY.CONTRACT_TAT END-BA_VIEW_WO_SUMMARY.NET_TAT) WO_DAYS_LEFT, (SELECT BA_VIEW_SHIPPING_ORDERS.DUE_DATE-SYSDATE) SO_DAYS_LEFT, 
                         (SELECT sysdate-BA_VIEW_SHIPPING_ORDERS.ENTRY_DATE WHERE ORDER_TYPE = 'RO') RO_DAYS_LEFT, (SELECT SYSDATE-BA_VIEW_SHIPPING_ORDERS.ENTRY_DATE WHERE ORDER_TYPE = 'WHS') WHS_DAYS_LEFT 
FROM            BA_VIEW_SHIPPING_ORDERS LEFT OUTER JOIN
                         BA_VIEW_WO_SUMMARY ON BA_VIEW_SHIPPING_ORDERS.ORDER_NUMBER = BA_VIEW_WO_SUMMARY.WO_NUMBER LEFT OUTER JOIN
                         DEPARTMENT ON BA_VIEW_SHIPPING_ORDERS.DPT_AUTO_KEY = DEPARTMENT.DPT_AUTO_KEY
WHERE        BA_VIEW_SHIPPING_ORDERS.SM_NUMBER LIKE 'SHA%' AND (BA_VIEW_SHIPPING_ORDERS.STATUS NOT IN ('SHIPPED', 'CANCELLED')
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros