Virtual column not allowed here in select statement

From: mittalashish <mittalashish_at_yahoo.com>
Date: 4 Nov 2002 19:39:47 -0800
Message-ID: <3cb58f22.0211041939.55cb1ad1@posting.google.com>

I have this query which gives me ORA-01733

select count(*)
from     

"W_PRODUCT_D" T23336,

     


     "W_PRODUCT_DH" T23752,

     


     "W_SYND_DATA_F" T23431

where
T23336."TYPE" = 'ZYX' and
T23752."TOP_LVL_PROD_NAME" = 'ABCD' and DATA_TYPE=1
and T23336."ROW_WID" = T23752."PROD_WID" and T23336."ROW_WID" = T23431."PROD_WID"
group by T23752."LVL7ANC_PROD_NAME", T23752."TOP_LVL_PROD_ID"

however, commenting out the first condition so that the query looks like this:

select count(*)
from     

"W_PRODUCT_D" T23336,

     


     "W_PRODUCT_DH" T23752,

     


     "W_SYND_DATA_F" T23431

where
--T23336."TYPE" = 'ZYX' and
T23752."TOP_LVL_PROD_NAME" = 'ABCD' and DATA_TYPE=1
and T23336."ROW_WID" = T23752."PROD_WID" and T23336."ROW_WID" = T23431."PROD_WID"
group by T23752."LVL7ANC_PROD_NAME", T23752."TOP_LVL_PROD_ID"

works fine. The doc says this error occurs when inserting into a view. But there is no view here. Any help will be appreciated. Received on Mon Nov 04 2002 - 21:39:47 CST