troubleshooting Question

query help

Avatar of nav29
nav29 asked on
Oracle Database
7 Comments1 Solution545 ViewsLast Modified:
hi there
when i am running this query no issue
SELECT nvl(po.person_id,ap.employee_id) person_id,
              po.cost_centre po_cost_centre,
              ap.cost_center ap_cost_centre, ap.signing_limit ap_signing_limit
         FROM vzn_po_subordinate_cst_ctr_gtt po FULL OUTER JOIN
              ap_web_signing_limits ap
              --,gl_sets_of_books sob
              ON (po.person_id = ap.employee_id AND po.cost_centre = ap.cost_center)
        WHERE nvl(ap.document_type,'APEXP') = 'APEXP'
       -- and po.SET_OF_BOOKS_ID = sob.SET_OF_BOOKS_ID


when i run this one i get error missing keyword

SELECT nvl(po.person_id,ap.employee_id) person_id,
              po.cost_centre po_cost_centre,
              ap.cost_center ap_cost_centre, ap.signing_limit ap_signing_limit
         FROM vzn_po_subordinate_cst_ctr_gtt po FULL OUTER JOIN
              ap_web_signing_limits ap
              ,gl_sets_of_books sob
              ON (po.person_id = ap.employee_id AND po.cost_centre = ap.cost_center)
        WHERE nvl(ap.document_type,'APEXP') = 'APEXP'
        and po.SET_OF_BOOKS_ID = sob.SET_OF_BOOKS_ID
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
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 7 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