Thanks for replying. The requirement is

INSERT INTO Server A. Database A. Table A

SELECT col1, col2, col3....

FROM Server B.Database B. Table B JOIN

Server C.Database C. Table C ON ........

WHERE DateID =...