jspc
asked on
SQL Script - DELETE
Hello,
I have a SQL Script below:
delete transdetails
FROM transdetails, transheaders
WHERE transdetails.transactionid = transheaders.transactionid and transheaders.batchnumber = 18
If I wanted to include multiple 'batch' numbers in the script how can I do this?
EG:
delete transdetails
FROM transdetails, transheaders
WHERE transdetails.transactionid = transheaders.transactionid and transheaders.batchnumber = 18,19,20,21
I have a SQL Script below:
delete transdetails
FROM transdetails, transheaders
WHERE transdetails.transactionid
If I wanted to include multiple 'batch' numbers in the script how can I do this?
EG:
delete transdetails
FROM transdetails, transheaders
WHERE transdetails.transactionid
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.