Orange Coast Database Forums

Post Info TOPIC: Access SQL


Directeur

Status: Offline
Posts: 42
Date:
Access SQL


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.

__________________
Anonymous

Date:
Access SQL Delete Query with Join


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));


__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  


Create your own FREE Forum
Report Abuse
Powered by ActiveBoard