How to compare tables in 2 database using SQL query

Hi Team,

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.


select * from A1.config where column_Name=‘value’ value that you got from A1.grant if execute this query if you found the rows count >0 means you have value exist in A1.config


okay thanks that perfect

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.