Thanks for quick reply Quentin. We need common Id's from both teradata servers tables based on where condition We filtered two server tables.We have big data in both Teradata servers, so, the reason if I filter the data from Teradata server-1 it will get huge Id's and server-2 as well. My question is I want to execute both Teradata server tables with join condition and apply the where clause same time then will get common Id's . ... View more