Search:

I find two solutions with SQL and esProc on cross database computing, like belows, hope for a Java solution.

With SQL:
SELECT salesMan
FROM (SELECT salesMan,
row_number() OVER...

There are 2 frequently-updated Excel sheets, the clients and the orders. We need to find out which clients in the Excel sheet have bought all products in the list by importing a dynamic product list....

hi,
It seemed some hard. But let make it easy to solve.....by esproc.
check this url:http://www.esproc.com/library/model_details/a-query-language-over-perform-sql.html

read first post: TAKE 30 SECONDS TO READ THIS BEFORE YOU POST! State what database are you using!