Thanks Jay it worked with the double FROM WTRDET statement. Its strange though while i was testing SQL with the same SELECT * query it gave me an error. But worked fine with the DELETE STATEMENT. Thanks once again for your time and help.