I have 2 Tables, table 1 has the last sequence No. The other has all the product data, I'm trying to find products that are greater than the Last Sequence No with some filtering criteria and then add those records to another Product table.
I then will use the highest sequence No from the updated Product table to update the Last Sequence Table.
The result was an empty query. I have attached a picture of the query,