Re: Deleting Unmatched records
- From: arthurjr07@xxxxxxxxx
- Date: 23 May 2006 20:23:29 -0700
try
DELETE*FROM tbl2
WHERE Key1 NOT IN
(SELECT Key1 FROM tbl1)
Be sure to back up
tbl2 before you do some
experiments.
.
- Prev by Date: Re: Subqueries
- Next by Date: Re: Sum Producing Negative Numbers
- Previous by thread: How do I check if there is a field in a query?
- Next by thread: Re: Deleting Unmatched records
- Index(es):
Loading
