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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])