help-query calcs

  • Thread starter Thread starter Guest
  • Start date Start date
Hi,

Can you add precisions?


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.
 
thanks much
-----Original Message-----
Hi,

Can you add precisions?


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.







.
Click to expand...
 
Back
Top