help-query calcs

[Guest]

I have a table
A 10
B 20

How do delete 10(A) from 20(B)in one query?

Thanks

 

[Michel Walsh]

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.

 

[Guest]

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.







.