Delete query syntax trouble

[TheSmileyCoder]

I have a table tbl_Dialog:
KEY_Dialog, ID_Obs .....

Table tbl_Obs
KEY_Obs, ID_Review .....

They are linked by KEY_Obs and ID_Obs, and I want to delete all records in tbl_Dialog having ID_Review=1200.

I tried:

myDB.Execute "DELETE tbl_Dialog.* FROM tbl_Dialog INNER JOIN tbl_Obs ON (tbl_Dialog.ID_Obs=tbl_Obs.KEY_Obs) " & _
         '            " WHERE (((tbl_Obs.ID_Review) In " & listRelatedReviews(lngRevID) & ") AND (tbl_Dialog.dt_Date=" & formatSQLdate(dtSubmittal) & "));"

ListRelatedReviews will return a string containing other relevant Review IDs, in this case the string returned would be "(1200,472)"

My problem is that instead of only deleting the records in tbl_Dialog, the code also deleted the records in tbl_Obs.

What should I change to only delete the records from tbl_Dialog?

[Rabbit]

Take out the join and filter using a subquery in the where clause.

[dsatino]

You may have a relationship between the fields with a cascading deletion.

[NeoPa]

I suggest you post the actual SQL code run, rather than the code which creates it - which doesn't appear to match the comments in the post as it stands.

As it stands, the syntax appears to be correct, but there's no filtering in this version so ...