Wei,
> I want to select some data out of database A, and insert them into database B. Is it possible to do in one SQL query?>
No. Use a Perl script.
-- -Josh Berkus Aglio Database Solutions San Francisco