How to delete records from a table based on an inner join Access 9

G

Guest

I am trying to delete records from table A, based on an inner join with table
B. Tables A and B both contain an invoice #.
 
G

Guest

I resolved my problem by looking at a post / reply from John Spencer on
12/08/04. I see the same question I posted several times. I added
DISTINCTROW
 

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

perform INNER JOIN on query results 2
Delete Records from Table INNER JOIN 1
Specify the table containing the records you want to delete 9
opposite of inner join; exclude rather than match 3
An Inner Join on an Inner Join 1
How does one report a bug in Access 2007 SQL? 4
Delete query with joined tables 0
delete Using Join Statement 4

Top