Invalid Identifier Error

I'm trying to write a query with the following code:

left outer join APVENMAST on PROCUREGRP.VENDOR_GROUP=APVENMAST.VENDOR_GROUP and POVARGMTHD.VENDOR=APVENMAST.VENDOR

But get the following error:
ORA-00904: "POVARGMTHD"."VENDOR": invalid identifier
00904. 00000 -  "%s: invalid identifier"

I've written another simple query and everything works.
SELECT *
FROM PROD.POVAGRMTHD pov,
     PROD.APVENMAST apv
     
where apv.vendor_group = pov.procure_group
and   apv.vendor = pov.vendor

Can someone tell me what I might be missing to correct the issue.
metalteckAsked:
Who is Participating?
 
larryhConnect With a Mentor Sr. Software EngineerCommented:
The typo pointed out by @Henka would be the first thing to check.  If that's not the issue...

Your problem query has this expression
POVARGMTHD.VENDOR

Your query that works has
PROD.POVAGRMTHD

It may be your problem query needs to be corrected to the following:
left outer join APVENMAST on PROCUREGRP.VENDOR_GROUP=APVENMAST.VENDOR_GROUP and PROD.POVAGRMTHD.VENDOR=APVENMAST.VENDOR

where you add the "PROD." to the table name.
0
 
Helena Markováprogrammer-analystCommented:
There is misspel

POVARGMTHD.VENDOR=APVENMAST.VENDOR

this is ok
PROD.POVAGRMTHD pov, ..
0
 
awking00Commented:
Your first query shows a left outer join while your second query is equivalent to an inner join.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.