Home » SQL & PL/SQL » SQL & PL/SQL » Alais tables
Alais tables [message #151] Mon, 21 January 2002 14:22 Go to next message
Lance Pris
Messages: 40
Registered: January 2002
Member
I have the following SQL Statement but am getting and ORA-00904 Invalid Column Error. What Could I be doing wrong?

SELECT
Launch.oc_session_id
FROM
pt_client_eventdetails launch,
pt_client_eventdetails logout
WHERE
a.pc_session_user_name = 'tsokol'
and (logout.pc_event_op = 'LAUNCH' and logout.pc_event_op <> 'LOGOUT' and logout.pc_event_op <> 'SOLUTION_VIEWED')
and launch.pc_session_id = logout.pc_session_id
Re: Alais tables [message #154 is a reply to message #151] Mon, 21 January 2002 18:43 Go to previous messageGo to next message
Tamim
Messages: 23
Registered: October 2001
Junior Member
Shouldn't the first line in the where clause be either launch.pc_session_user_name = 'tsokol' or logout.pc_session_user_name = 'tsokol' and not 'a' since you don't have an alias with 'a'?
Re: Alais tables [message #157 is a reply to message #154] Tue, 22 January 2002 04:18 Go to previous message
Lance Pris
Messages: 40
Registered: January 2002
Member
You are correct but that is not where I am getting the ORA_000904 Invalid Column Error.

It is occuring where I try to join the tables.

Logout.pc_session_id = Launch.pc_session_id.

That is why I am confused about why it is occuring
Previous Topic: Error:table is mutating!
Next Topic: Insufficent privileges? referencing
Goto Forum:
  


Current Time: Mon Aug 02 10:16:00 CDT 2021