>
> 1: select * from FamilyFundInfo
> 2: WHERE ( PORTFOLIO_ID )
> 3: AND ( (PORTFOLIO_ID in (Select Portfolio_ID from PortfolioInfo
> 4: where Questionnaire_ID = ? /* Questionnaire_ID */ ))
> 5: )
> 6: ORDER BY Portfolio_ID ASC
> 7: , SORT_ORDER ASC
>
> I am not sure wher ehte "( PORTFOLOI_ID )" comes from (line 2)--I've
> done plenty of these before, seems so simple. What's up with it?

What are you trying to do with line 2?

Something like?

2: WHERE ( PORTFOLIO_ID = 5)

Your query does not make sense, neither does:

select *
from mytable
where fred

for the exact same reason.


Adam