Verify if each query result exists in other table

I have a query "GetPrs" that return some rows with some columns, one of the columns is "COD" other is "REF". I have a table "Info" with columns (COD, REF, DATE) and I want to verify for each result of the query "GetPrs" if the combination of the "COD" and "REF" already exists in the table "Info".

But Im not understanding how to properly achieve that, do you know how?

You can use the EXISTS operator.

Check this page for more details: https://www.sqlservertutorial.net/sql-server-basics/sql-server-exists/


I hope I helped you.

Hi OsCaR_,

My first assumption and question, is that this calculation might be performed as a database operation. But is that possible in the context of your application?