Hi all please help.
I'm trying to delete the selected data from a table colum from a select statement.
this is the select statement
SELECT RFC822 FROM SQLGOLDMINE.DBO.MAILBOX MB WHERE ((MB.CREATEON >= '2014-07-24' AND MB.CREATEON <= '2015-07-24') OR (MB.MAILDATE >= '2014-07-24' AND MB.MAILDATE <= '2015-07-24')) AND (MB.MAILREF LIKE '%auction notification & invitation%')
Can somebody please tell me what the delete statement would look like please. I've tried replacing Select with delete from but get a sytax error.
regards
Joe