help with MERGE

[Tommy de Jesus]

I need some help. (obviously)

I am running MySQL 4.1.7 on Windows.

I have two tables created mod_users and fin_mod_users. I need to drop fin_mod_user, recreate it and merge the two.

Here isthe query I have:

DROP TABLE IF EXISTS fin_mod_users;

CREATE TABLE fin_mod_users (
user_id int(10) unsigned NOT NULL default '0',
username varchar(20) binary NOT NULL default '',
password varchar(32) binary NOT NULL default '',
email varchar(50) default NULL,
admin_switch smallint(6) NOT NULL default '0',
groups text,
deity smallint(6) NOT NULL default '0',
log_sess int(10) unsigned NOT NULL default '0',
last_on int(10) unsigned NOT NULL default '0',
cookie varchar(32) default NULL,
PRIMARY KEY (user_id)
) ENGINE=MyISAM UNION=(mod_users) INSERT_METHOD=LAST;

it creates the table structure it seems, but no data appears. any suggestions?