Put your "SQL View" posts here. Yes, this is similar to the queries topic. Use that one in general, this one if you are working directly in SQL view. We have a class related specifically to this subject so that is why we created this board topic.
Here is an Access Delete Query with an embedded join. Sometimes the syntax can be a bit tricky so I thought I would post this. It deletes labor records for employees with an hourly rate greater than $20.
DELETE Labor.* FROM employees2
INNER JOIN Labor
ON employees2.EmpNo = Labor.EmpNo WHERE (((employees2.Rate)>20));
