Query Issue

[firoz.raj]

The following inner querey return 9/9/2012 7:45:21 AM .
so simple i want all the records from OracleTradingSummaryDetail .which is matching with
SELECT Max(TradingSummaryStatus.UPDATEDTIME

but when i running the following query it is asking UpdatedTime as a parameter .why ? it needs to show all the matching rows .

SELECT *
FROM OracleTradingSummaryDetail
WHERE UPDATEDTIME=
(SELECT Max(TradingSummaryStatus.UPDATEDTIME) as LastSalesDate
FROM TradingSummaryStatus
WHERE Status<>'C');