Nested query issue, Invalid Identifier error

Question

I am running following query in Oracle 10 XE and getting [Err] ORA-00904: "Q": invalid identifier

SELECT questions.sb_title Q,questions.sb_baab_id,questions.sb_fasal_id,QUESTIONS.SB_CONTENT answer,IST.SB_PREFERENCE PREF
FROM USER_QUESTIONS questions
INNER JOIN USER
ON QUESTIONS.SB_USER_ID = USER.SB_ID
INNER JOIN IST 
ON IST.SB_ID = USER.SB_IST_ID
AND(Q  LIKE '%where is%') 
AND USER.SB_IST_ID = 
(
    Select issued.SB_IST_ID
    FROM USER_REGISTER register_number
    INNER JOIN USER_ISSUED issued
    ON register_number.SB_REGISTER_NUMBER = ISSUED.SB_REGISTER_NUMBER
    AND REGISTER_NUMBER.SB_REGISTER_NUMBER IN(1240)
)

Correct me if I'm wrong, but shouldn't you declare the alias using AS? — Sterling Archer
– Sterling Archer, Commented Oct 1, 2013 at 14:54
In Oracle you don't have to use the AS keyword for aliases - providing the alias after a column works just fine. — Przemyslaw Kruglej
– Przemyslaw Kruglej, Commented Oct 1, 2013 at 14:58

Przemyslaw Kruglej · Accepted Answer · 2013-10-01 14:57:45Z

1

You cannot reference an alias in the JOIN condition - write the actual column name: sb_title.

answered Oct 1, 2013 at 14:57

Przemyslaw Kruglej

8,1412 gold badges30 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrew · Accepted Answer · 2013-10-01 14:58:11Z

0

I don't think you can use the alias "Q" like that. You're aliasing it in your select clause, don't think you can use that alias in your ON clause. Try using the full column name (sb_title).

answered Oct 1, 2013 at 14:58

Andrew

8,8933 gold badges31 silver badges54 bronze badges

Collectives™ on Stack Overflow

Nested query issue, Invalid Identifier error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related