Hi all,

There are two similar tables in 2 different schemas/databses that contain employee information.

I have a requirement to get the list of the emp ids from those two tables whose sum of the count in the above tables is less than or equal to a user defined value.

This is a wierd requirement but we need this for the data setup for one of our important performance tests.


Example:

Emp_ids 1, 2 and 3 exist both in table A and table B.

For emp_id 1, table A has 20 records for that emp_id and table B has 20 records => sum of counts = 40

For emp_id 2, table A has 40 records for that emp_id and table B has 40 records => sum of counts = 80

For emp_id 3, table A has 100 records for that emp_id and table B has 100 records => sum of counts = 100

User wants only those emp_ids whose sum of count from both tables is less than or equal to 80.

Thus the result of the sql must be emp_id 1 and 2 only.

How do I do that?

I tried few things but in vain.

Any help is appreciated.

Thanks in advance for your time and interest.