OraFAQ Forum: Client Tools » help with outer join sql -

Home » Other » Client Tools » help with outer join sql -

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

help with outer join sql - [message #25853]

Wed, 21 May 2003 08:26

Eric Desai
Messages: 1
Registered: May 2003

Junior Member

I have the following sql:

SELECT LED.LOG_EVENT_DATA_ID,
LED.REQUEST_ID,
LED.SESSION_KEY,
LE.SEVERITY_DESC,
LED.LOG_EVENT_ID,
LED.LOG_CATEGORY_ID,
LED.LOG_SOURCE_ID,
LS.HOST,
LS.NAME,
LED.BINDATA,
LED.EVENT_DATE,
SEC_DATA_EXISTS
FROM LOGSECURITY.LOG_EVENT_DATA LED,
LOGSECURITY.LOG_SOURCE LS,
LOGSECURITY.LOG_EVENT LE
LEFT OUTER JOIN (SELECT DISTINCT 'TRUE' AS SEC_DATA_EXISTS, LOG_EVENT_DATA_ID
FROM LOGSECURITY.SIGN_ON_INFORMATION) ON LED.LOG_EVENT_DATA_ID = LOG_EVENT_DATA_ID
WHERE LED.LOG_SOURCE_ID=LS.LOG_SOURCE_ID
AND LE.LOG_EVENT_ID=LED.LOG_EVENT_ID

Whenever I run it, I recieve the following error:

FROM LOGSECURITY.SIGN_ON_INFORMATION) ON LED.LOG_EVENT_DATA_ID = LOG_EVE
*
ERROR at line 17:
ORA-00904: "LED"."LOG_EVENT_DATA_ID": invalid identifier

Is this a bug? Can anyone explain what the problem is?

Thanks for your help.

Report message to a moderator

Re: help with outer join sql - [message #25922 is a reply to message #25853]

Mon, 26 May 2003 23:39

kaotuka raaman
Messages: 1
Registered: May 2003

Junior Member

FROM LOGSECURITY.SIGN_ON_INFORMATION) ON LED.LOG_EVENT_DATA_ID = LOG_EVENT_DATA_ID

pls check both

LED.LOG_EVENT_DATA_ID = LOG_EVENT_DATA_ID

in RHS u have not mentioned table alias.

Report message to a moderator

Previous Topic:	features of oracle8i, 9i and 11i
Next Topic:	Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 09:43:54 CDT 2024