|Subject||Re: Exception with SQL|
>What are you trying to do with line 2?
> 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?
2: WHERE ( PORTFOLIO_ID = 5)
Your query does not make sense, neither does:
for the exact same reason.