Hi guys I’m looking to create a simple delete statement. I have a table that stores ref numbers. I want to delete the records in the column RefNo where the TenderTypeKey = 3.
It's basically the records that are returned in this select statement;
SELECT RefNo, TenderTypeKey
FROM dbo.tcmCashRcptDetl
WHERE (TenderTypeKey = 3)
I do not want to delete all the rows in the table with a TenderTypeKey of 3, just the records stored in the column RefNo.
Thanks in advance!
It's basically the records that are returned in this select statement;
SELECT RefNo, TenderTypeKey
FROM dbo.tcmCashRcptDetl
WHERE (TenderTypeKey = 3)
I do not want to delete all the rows in the table with a TenderTypeKey of 3, just the records stored in the column RefNo.
Thanks in advance!