
So, I have these two tables. One table is Request, and the other table Submission. Both tables have a process ID so the way it works is each process will have a number of requests and all requests in a process will have the same submission names. I want to write a query that gives me the list of submission names where the process id is the same in both tables.
Some things I am not sure on: