I have two SELECT queries returning datasets from two different tables that I know for a fact will share some id’s.
setA = system.db.runQuery(query1)
setB = system.db.runQuery(query2)
The first column of each set is an id. I want to know what id’s appear in setA that do not exist in setB. This way I can run insert statements for those specific Id’s and update statements for the rest (I am using info from setA to update setB later). Is there an easy way to do this or am I going to be stuck in loop hell?