I want to do this:
Write a DML statement to DELETE all records in the ENROLLMENT_MASTER for any member which exists in the OHIO_MEMBERS table
This Statement shows no error. Also no data is returned and it is correct when I examine the two tables and the join. i think that they put the wrong data in the OHIO_MEMBERS table. I stay with it as is for now. I'll fix the data to what I think it should be. The company I took the test from is local. The test was 5 mins to look at the tables. 40 minutes to figure out the rest. I have been at this for weeks and I'm finally on the last question.
I'm considering stopping by in person and asking to speak with a manager and ask if their test had an intentional error. Perhaps they will be impressed and it would be an opening to set up an interview.
I want to DELETE the rows in the ENROLLMENT_MASTER table.
ORA-00933: SQL command not properly ended
It might a WHERE clause in addition to the ON clause. I'll go try that. Can you tell what part of the ending is missing?
After submitting my question, CodeRanch recommended looking at another post from 20 years ago. It is very close to my question. I will use it and see if I get closer.