ACCESS 2013 Query
I want to delete records from table 1 with inner join. My query is
Delete Table1.* from Table1
Inner Join Table2 on Table1.invoice=Table2.Invoice
The above query works but it deletes records from Table2. I switched Table1 with Table2 but it still deletes records from Table2. How can I delete records from Table1?
Thank you very much in advance.