API and WPH are related through the common field PersonID,
while WPH and SelectedEvent are related through the common field WalkNumber.
I want to create an Access SQL DELETE query to delete all records in WPH
where WPH.WalkNumber = SelectedEvent.WalkNumber
and ATI.Response IN ("C","D");
but I can't quite get an SQL statement that works.
I tried creating the query through the design view, and the resultant SQL was
Expand|Select|Wrap|Line Numbers
- DELETE Walk_participation_history.*, Applicant_Transient_info.Response
- FROM (Walk_participation_history INNER JOIN SelectedEvent ON Walk_participation_history.WalkNumber = SelectedEvent.WalkNum) INNER JOIN Applicant_Transient_info ON Walk_participation_history.PersonID = Applicant_Transient_info.PersonID
- WHERE (((Applicant_Transient_info.Response) In ("C","D")));
I thought a Select query was equivalent to a table, but evidently not.
Is what I want to achieve doable?