DELETE DATA FROM TABLE BASE ON OTHER TABLE 1

[pelagic]

Hi there,

I have tableA, in table A I have the following serial number

SerialNo
1
2
3
4
5

in tableB I have the following serial number.
SerialNo
3
4
5
How would I delete 3 4 5 number from tableA but base on the value from tableB


Thanks,

 

[Remou]

If SerialNo is the primary key in TableB, this:
[tt]DELETE TableA.*
FROM TableA INNER JOIN TableB ON TableA.SerialNo = TableB.SerialNo;[/tt]
Should work.

 

[PHV]

Another way:
DELETE FROM tableA WHERE SerialNo IN (SELECT SerialNo FROM tableB)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886