How to know the data exists in one table box is not exists in another table box?

[#1]

Hi,

I have two table boxes.

Table Box A contains data from Access. Table Box B contains data from SQL.

How can I know whether the data exists in Access Table Box is not present in SQL Table Box without making any selections one by one. Please can anyone suggest me.

Thanks.

[#2]

Please see sample.

[its_anandrjs]

Check data with keys from which key that joins or associate or make a right join or left join

Hope this helps

[sivarajs]

Generate a flag in each table at the time of load

Ex. Load *,'Access' as Flag from table;

Load *,'SQL' as Flag from table;