Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete from a Table

Status
Not open for further replies.
pbcharlie

pbcharlie

Technical User
Jan 16, 2002
55
How do I write a query that will delete account numbers from table two that are in table one? Thanks in advance
Charlie
 
Sort by date Sort by votes
Delete * from [TableTwo] Where AccountNumber In (Select AccountNumber From [TableOne]);

Good luck

[pipe]
Daniel Vlas
Systems Consultant
 
Upvote 0 Downvote
Thanks this has helped alot
Thanks in advance
Charlie
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheAceMan1
  • Locked
  • Question
Delete from listi n XL open tab with VBA
Replies
2
Views
390
TheAceMan1
TheAceMan1
BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
2K
dhookom
dhookom
Moss100
  • Locked
  • Question
Transfer data from external table to identical local table - urgent please
2
Replies
27
Views
807
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
776
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Add multiple contacts to outlook - from access table
Replies
12
Views
502
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top