You have 10 records in table A and 20 records in table B and you want to
delete records from table B that are in Table A ? The following may be a
first attempt:
DELETE DISTINCTROW tableB.* FROM tableA INNER JOIN tableB ON
tableA.key=tableB.key
where "key" is the assumed primary key field than can identify the "match"
between records.
You have 10 records in table A and 20 records in table B and you want to
delete records from table B that are in Table A ? The following may be a
first attempt:
DELETE DISTINCTROW tableB.* FROM tableA INNER JOIN tableB ON
tableA.key=tableB.key
where "key" is the assumed primary key field than can identify the "match"
between records.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
