How can we help you today? How can we help you today?

Can not find a column from the where clause

When I type:

select od.[ORDERID], od.[FINALPRODUCTID], od.[HEEL], o.[orderCategory], od.[CustomerOrderDetailId]
from [dbo].[ORDERSDETAIL] od
join [dbo].[ORDERS] AS o
where F

I expect to be able to find the FINALPRODUCTID column but all column names are filtered from the canidate list. I am left with function names and keywords.

Query Analyzer
DaveTheWave
0

Comments

3 comments

Sort by
  • DaveTheWave
    If I add an ORDER BY or GROUP BY clause and invoke the canidate list and search for items that begin with 'F' as below:

    select od.[ORDERID], od.[FINALPRODUCTID], od.[HEEL], o.[orderCategory],
    od.[CustomerOrderDetailId]
    from [dbo].[ORDERSDETAIL] od
    join [dbo].[ORDERS] AS o
    where F
    order by od.[FINALPRODUCTID]

    All canidates are filtered out of the list.
    DaveTheWave
    0
  • Lionel
    Thanks for the feedback. This looks like it is being caused by our passer having problems with incomplete SQL. I have entered it into our bug tracking system for fixing.

    Lionel
    Lionel
    0
  • DaveTheWave
    I tried this again with a complete join clause and the problem presisted.
    DaveTheWave
    0

Add comment

Please sign in to leave a comment.