Problem doing inner select with MySql

[bob morkos]

I have the following code, can somoene tell me what I did wrong? Thanks in advance.
Select ProfitLoss, Name, DatePosition
FROM interestprofit
Where Security = '13508754'
And TraderName = 'CAN'
GROUP BY TraderName, Security
Having DatePosition IN (Select DatePosition FROM interestprofit WHERE DatePosition = MAX(DatePosition))

[Bear Bibeault]

 

can somoene tell me what I did wrong?

Yes, you didn't tell us what the problem was.

[Jason Steele]

Haven't tried it but shouldn't it be:

Select ProfitLoss, Name, DatePosition
FROM interestprofit
Where Security = '13508754'
And TraderName = 'CAN'
GROUP BY TraderName, Security
Having DatePosition IN (Select Max(DatePosition) FROM interestprofit)

[bob morkos]

Yes, that would do it. Thanks

Originally posted by Jason Steele:
Haven't tried it but shouldn't it be:

Select ProfitLoss, Name, DatePosition
FROM interestprofit
Where Security = '13508754'
And TraderName = 'CAN'
GROUP BY TraderName, Security
Having DatePosition IN (Select Max(DatePosition) FROM interestprofit)