Hello all,
I'm having some problems with the following DELETE query:
DELETE TblHistory.*
FROM TblHistory, TblHistoryTemp
WHERE TblHistory.Name = TblHistoryTemp.Name
AND TblHistory.Release = TblHistoryTemp.Release
AND TblHistory.Period = TblHistoryTemp.Period;
When running it, I receive this message: Could not delete from specified tables. I'm a bit new with this, but I'm guessing that SQL doesn't like the way I listed the two tables. All examples I've seen using the "DELETE" command are only for one table. How do I get the query to work based on those criteria?
All help would be greatly appreciated!
Thanks!