I have tables all with the same columns and have divided them up this way to keep them small.

e.g.
Tables - cpus, gfxcards, monitors.
Columns - titleId, categoryId, name.

What I'm trying to do is similar to this

```
SELECT * FROM cpus
UNION
SELECT * FROM gfxcards;
DELETE FROM test WHERE (titleId,categoryId) IN ((2,0));

```

Is there a way to do this or do I have to use transactions to avoid multiple delete queries?