Alais tables [message #151] |
Mon, 21 January 2002 14:22 |
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 |
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 |
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
|
|
|