Jay, i am using SQL server 7.0

Here's the query and the error results:

DELETE

FROM WTRDET

INNER JOIN

(

SELECT Order_NBR ,Line_NBR, MAX(Ship_Date) as MaxShipDate

FROM WTRDET GROUP BY Order_NBR ,Line_NBR

) AS dt

ON WTRDET.Order_NBR = dt.Order_NBR

AND WTRDET.Line_NBR = dt.Line_NBR

AND WTRDET.Ship_Date < dt.MaxShipDate

Error result:

Server: Msg 156, Level 15, State 1, Line 3

Incorrect syntax near the keyword 'INNER'.

Server: Msg 156, Level 15, State 1, Line 7

Incorrect syntax near the keyword 'AS'.