I have a select query that pull records based on certain where criteria. I want the recordIDs that are returned to be used in another query to see if the ID exists?
For example Select Query 1 pulls all records with a open status.
I want to have another query run taking the IDs found open in Query 1 to see if that ID exists with a closed status
For example Select Query 1 pulls all records with a open status.
I want to have another query run taking the IDs found open in Query 1 to see if that ID exists with a closed status