Delete Query

  • Thread starter Thread starter Bart Bailey
  • Start date Start date
B

Bart Bailey

Here's the problem. I have 2 tables.
Table A
Account Number Desc Name

Table B
Account Number Desc Name


I need to delete the record in Table B if the Account Number in Table A
equals an Account Number in Table B

thanks
 
DELETE * FROM [Table B] WHERE [Table B].[Account Number] In(SELECT [Account
Number] FROM [Table A]);

Hope This Helps,

Sam
 
Thanks, that worked!!


OfficeDev18 via AccessMonster.com said:
DELETE * FROM [Table B] WHERE [Table B].[Account Number] In(SELECT
[Account
Number] FROM [Table A]);

Hope This Helps,

Sam

Bart said:
Here's the problem. I have 2 tables.
Table A
Account Number Desc Name

Table B
Account Number Desc Name

I need to delete the record in Table B if the Account Number in Table A
equals an Account Number in Table B

thanks
Click to expand...
Click to expand...
 
Back
Top