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:
- what action what I use to do that? Would it be list rows and the table submission? Then would I write the query in the select columns field or select rows to get the submission names?
- I have been looking around, and not sure what the query would look like, or how to get started on that? Is it possible to get an example?


Report
All responses (
Answers (