sql - DELETE in [validating two fields] -
i (and find) seeking ways validate 2 fields delete.
i.e. delete x_table idreserva in (.........)
, might work, there series associated same numbers, , likelihood of more things eliminate me accurate, 100%. possessing different series, different numbers.
ie baao/300. caao/300.
with above statement, deleted 2 records, , above wanted eliminate: baao/300.
i looking like:
delete x_table idreserva , serie in (.........)
or if there otherwise grateful.
your statement right, it's not sql valid,
can use following valid statement:
delete x_table idreserva in (...) , serie in (....)
Comments
Post a Comment