Delete Query

  • Thread starter Thread starter Boon
  • Start date Start date
B

Boon

Hi,

When I use inner join, or just a normal join, sometimes Access didn't allow
me to delete the records. Sometimes it allows me to delete, sometiems it
doesn't.

Here is a SQL that it didn't allow me to delete.

DELETE Dealer_BG.*
FROM Dealer_BG INNER JOIN Dealer ON Dealer_BG.DLRCD = Dealer.DLRCD;


What did I do wrong? I would appreciate if you would explain why I cannot
delete it.

Thanks,
B
 
Try:


DELETE DISTINCTROW Dealer_BG.*
FROM Dealer_BG INNER JOIN Dealer
ON Dealer_BG.DLRCD = Dealer.DLRCD;



Vanderghast, Access MVP
 
Back
Top