Moving between databases

How would I go about moving or copying data between databases on the same
server, without actually doing a dump ?  Using an SQL statement,
something like:

SELECT dbase_a.sometable.somefield INTO dbase_b.sometable FROM dbase_a.sometable

Mark.
--