Search results

That works great for me. Thank you so much. Is there a web link/ source where I can learn this from? I have done a lot of queries (mostly simple) before but was unaware of using the same table (alias) for results like this. Thanks you again, Baapi

Thanks but, not working... your SQL SELECT COUNT(*) FROM history T1 INNER JOIN (SELECT T2.HistoryID, MAX(T2.DateStamp) AS DateStamp FROM history T2 WHERE T2.DateStamp<=[ParamDateStamp] GROUP BY T2.HistoryID) T2 ON T1.HistoryID=T2.HistoryID AND T1.DateStamp=T2.DateStamp WHERE...

Dear All, I have a MAIN table which stores the most recent info of a record with following details: Unique_Ref_Num|Status|Dept 1 |6 | 1 and a second table called history which records changes in the main table HistoryID | Status | DateStamp 1 | 1 | #22/10/2007...