Find unmatched Query

  • Thread starter Thread starter Robert Whitney
  • Start date Start date
R

Robert Whitney

Once you run an un-matched query, How do you delete the Un-
Matched records from the source table? I have about 4,000
un-matched records that I want to delete; p.s. and have
no other criteria other than the records in one of the
tables "not matching".
 
Change this from a Select Query to a Delete Query. Make
sure that the items is the list are only the ones you want
to get rid of.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query-finding umatched data with duplicates 5
Matched Query 2
Unmatched query question 3
NOT IN (SQL) or Find Unmatched (+ other stuff) 21
compare and unmatched 8
Weird 2007 left join query 1
Finding missing records between two tables 5
Finding Unmatched Rows 2

Back
Top