LifeinAsia - 4:55 pm on Dec 7, 2010 (gmt 0)

It depends on what database you're using. For example, if you're using MS SQL, the following should work (assuming you have the proper permissions for both databases):
INSERT INTO b.dbo.data (test)
SELECT a.dbo.data.test
WHERE test=0