Thanks a lot for your suggestions.

Actually I received this query from my client and he want it in sql.

I converted it properly except that 'Like ' clause.

Once again thanks...

When I tried this(By skipping Positions.Ticker in Join) it's working As...

FROM maintSubStrategySecurityType RIGHT JOIN (qryBlackrockHaircuts

RIGHT JOIN (((qryBlackrockReturn RIGHT JOIN (qryBlackrockRatings RIGHT JOIN

(tblFXRates RIGHT JOIN (maintBlackrockPortfolio RIGHT JOIN...

hi

still I am geting problem

I have used the condition in where clause and kept that column name in the join

but still showing error

incorrect syntax near or..

the complete from...

Thanks for you reply

I am using this statement in the from clause as

LEFT JOIN qryPNLByFund ON

((case when Positions.Ticker<>'' And Positions.Ticker NOT IN ('SPY', 'LEH', 'BA', 'DHI',...