In my current process i have to use, database connection for maintaining DB
for eg A1.Grant and A1.Config are my two tables
one column value in A1.grant , i want to check whether this text is present in A1.config table or not
any clue anyone how to do it? with SQL Query. I have used lookup activity it worked fine but need to do it through SQL query to maintain database and not datatable.