İki ayrı tabloyu birleştirmek

arkadaşlar joomla kullanıyorum ve mister estate bileşenini kullanıyorum 1.6.0 fakat ondan çok daha güzel bir bileşen var ea improved diye; şimdi mister estatedeki emlaklarımı ea improved'e taşımak istiyorum bu konuda fazla bilgim yok sadece ufak tefek değişikliklerle kategorileri geçirebildim...

Mister Estate'nin sql'i (Asıl Veri):

CREATE TABLE IF NOT EXISTS `jos_misterestate` (
  `id` int(10) NOT NULL auto_increment,
  `obj_id` varchar(25) NOT NULL default '',
  `cat` tinyint(4) NOT NULL default '0',
  `type` tinyint(2) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `location` text NOT NULL,
  `condition` text NOT NULL,
  `other` text NOT NULL,
  `rooms` smallint(4) NOT NULL default '0',
  `bedrooms` smallint(4) NOT NULL default '0',
  `wc` smallint(4) NOT NULL default '0',
  `space` decimal(10,2) NOT NULL default '0.00',
  `homes` smallint(5) NOT NULL default '0',
  `homes_size` decimal(10,2) NOT NULL default '0.00',
  `pp_size` decimal(10,2) NOT NULL default '0.00',
  `trade_units` smallint(5) NOT NULL default '0',
  `trade_size` decimal(10,2) NOT NULL default '0.00',
  `position` varchar(50) NOT NULL default '',
  `lift` tinyint(1) NOT NULL default '0',
  `handicap` tinyint(1) NOT NULL default '0',
  `yobuilt` varchar(10) NOT NULL default '',
  `toheat` tinytext NOT NULL,
  `toheat_ufloor` tinyint(1) NOT NULL default '0',
  `fireside` tinyint(1) NOT NULL default '0',
  `aircondition` tinyint(1) NOT NULL default '0',
  `tv` tinyint(1) NOT NULL default '0',
  `dsl` tinyint(1) NOT NULL default '0',
  `swpool` tinyint(1) NOT NULL default '0',
  `balcony` tinyint(1) NOT NULL default '0',
  `terrace` tinyint(1) NOT NULL default '0',
  `garden` tinyint(1) NOT NULL default '0',
  `parkarea` tinyint(1) NOT NULL default '0',
  `garage` tinyint(1) NOT NULL default '0',
  `rent` decimal(10,2) NOT NULL default '0.00',
  `rent_extra` decimal(10,2) NOT NULL default '0.00',
  `price` decimal(10,2) NOT NULL default '0.00',
  `commis` varchar(15) NOT NULL default '',
  `secure` decimal(10,2) NOT NULL default '0.00',
  `receipts` decimal(10,2) NOT NULL default '0.00',
  `street` varchar(255) NOT NULL default '',
  `streetnr` varchar(5) NOT NULL default '',
  `pcode` varchar(10) NOT NULL default '',
  `town` tinytext NOT NULL,
  `district` tinytext NOT NULL,
  `state` tinytext NOT NULL,
  `country` tinytext NOT NULL,
  `hits` int(6) NOT NULL default '0',
  `hot` tinyint(1) NOT NULL default '0',
  `metadesc` varchar(255) NOT NULL default '',
  `metakey` varchar(255) NOT NULL default '',
  `created` date NOT NULL default '0000-00-00',
  `created_by` int(11) NOT NULL default '0',
  `access` tinyint(3) NOT NULL default '0',
  `verified` tinyint(1) NOT NULL default '-1',
  `publish_up` date NOT NULL default '0000-00-00',
  `publish_down` date NOT NULL default '0000-00-00',
  `publish` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=385 ;

--
-- Tablo döküm verisi `jos_misterestate`
--

INSERT INTO `jos_misterestate` (`id`, `obj_id`, `cat`, `type`, `title`, `description`, `location`, `condition`, `other`, `rooms`, `bedrooms`, `wc`, `space`, `homes`, `homes_size`, `pp_size`, `trade_units`, `trade_size`, `position`, `lift`, `handicap`, `yobuilt`, `toheat`, `toheat_ufloor`, `fireside`, `aircondition`, `tv`, `dsl`, `swpool`, `balcony`, `terrace`, `garden`, `parkarea`, `garage`, `rent`, `rent_extra`, `price`, `commis`, `secure`, `receipts`, `street`, `streetnr`, `pcode`, `town`, `district`, `state`, `country`, `hits`, `hot`, `metadesc`, `metakey`, `created`, `created_by`, `access`, `verified`, `publish_up`, `publish_down`, `publish`) VALUES
(4, 'SY0002', 9, 2, 'KÖKÇELi SiTESi NDE SATILIK YAZLIK', 'SiTE iÇiNDE, ANAYOL ÜZERi DENiZ TARAFINDA DENİZE 100 METRE MESAFEDE ALÇI, SIVA, SATEN, KARTONPİYER, PVC BALKONLAR SERAMİK YAPILI VE BARBÜKÜLÜ, YERLER KALEBODUR, İÇ KAPILAR AMERİKAN PANEL, MUTFAK KOMPLE YAPILI, MASRAFSIZ SÜPER LÜX DAİRE (KULLANILMAMIŞ SIFIR DAİRE )', '', '', '', 2, 2, 1, 80.00, 0, 0.00, 0.00, 0, 0.00, '5', 0, 0, '2000', 'SOBALI', 0, 0, 0, 0, 1, 0, 1, 0, 1, 1, 0, 0.00, 0.00, 65000.00, '3', 0.00, 0.00, '', '', '33940', 'MERSİN SİLİFKE', 'SUSANOĞLU ( ATAKENT )', 'BELEDİYE YANI', 'TR', 5162, 0, 'MERSÝN, SUSANOÐLU, SATILIK, ATAKENT, SÝLÝFKE, KIZKALESÝ, KAPIZLI, EMLAK, SATILIK, YAZLIK, KÝRALIK', 'MERSÝN, SUSANOÐLU, SATILIK, ATAKENT, SÝLÝFKE, KIZKALESÝ, KAPIZLI, EMLAK, SATILIK, YAZLIK, KÝRALIK', '0000-00-00', 70, 0, 1, '2006-07-13', '0000-00-00', 1),
(117, 'SY0051', 9, 2, 'İLKEM SİTESİ''NDE ŞAHANE DENİZ MANZARALI', 'ŞAHANE DENİZ MANZARALI 100 METRE MESAFEDE DENİZE HER İKİ BALKONDAN DENİZ GÖRÜR SİTE İÇİNDE ÇELİKKAPI ALÇI SIVA SATEN KARTONPİYER İTHAL BOYA PİMAPEN SİNEKLİK YERLER VE BALKONLAR SERAMİK MERMER YAPILI 2 WC BANYO BARBÜKÜ GÜNEŞ ENERİSİ İÇİ ÇOK ÖZEL VE GÜZEL YAPILI MASRAFSIZ SÜPER LÜKS DAİRE ACİLEN SATILIK', '', '', '', 3, 3, 2, 130.00, 0, 0.00, 0.00, 0, 0.00, '3', 0, 0, '2000', 'KLİMA', 0, 0, 0, 1, 1, 0, 1, 0, 1, 1, 0, 0.00, 0.00, 80000.00, '3', 0.00, 0.00, '', '', '33940', 'MERSİN SİLİFKE', 'ATAKENT ( SUSANOĞLU )', 'PLAJ KARŞISI', 'TR', 1818, 0, '', '', '0000-00-00', 70, 0, 1, '2007-06-27', '0000-00-00', 1),

Geçirmek istediğim tablonun sqli:

CREATE TABLE IF NOT EXISTS `jos_estateagent` (
  `id` int(10) NOT NULL auto_increment,
  `obj_id` varchar(25) NOT NULL default '',
  `cat` tinyint(4) NOT NULL default '0',
  `type` tinyint(2) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `alias` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `location` text NOT NULL,
  `condition` text NOT NULL,
  `other` text NOT NULL,
  `rooms` smallint(4) NOT NULL default '0',
  `bedrooms` smallint(4) NOT NULL default '0',
  `wc` smallint(4) NOT NULL default '0',
  `space` decimal(10,2) NOT NULL default '0.00',
  `homes` smallint(5) NOT NULL default '0',
  `homes_size` decimal(10,2) NOT NULL default '0.00',
  `pp_size` decimal(10,2) NOT NULL default '0.00',
  `trade_units` smallint(5) NOT NULL default '0',
  `trade_size` decimal(10,2) NOT NULL default '0.00',
  `position` varchar(50) NOT NULL default '',
  `lift` tinyint(1) NOT NULL default '0',
  `handicap` tinyint(1) NOT NULL default '0',
  `yobuilt` varchar(10) NOT NULL default '',
  `toheat` tinytext NOT NULL,
  `toheat_ufloor` tinyint(1) NOT NULL default '0',
  `fireside` tinyint(1) NOT NULL default '0',
  `aircondition` tinyint(1) NOT NULL default '0',
  `tv` tinyint(1) NOT NULL default '0',
  `dsl` tinyint(1) NOT NULL default '0',
  `swpool` tinyint(1) NOT NULL default '0',
  `balcony` tinyint(1) NOT NULL default '0',
  `terrace` tinyint(1) NOT NULL default '0',
  `garden` tinyint(1) NOT NULL default '0',
  `parkarea` tinyint(1) NOT NULL default '0',
  `garage` tinyint(1) NOT NULL default '0',
  `rent` decimal(10,2) NOT NULL default '0.00',
  `rent_extra` decimal(10,2) NOT NULL default '0.00',
  `price` decimal(20,2) NOT NULL default '0.00',
  `commis` varchar(15) NOT NULL default '',
  `secure` decimal(10,2) NOT NULL default '0.00',
  `receipts` decimal(10,2) NOT NULL default '0.00',
  `street` varchar(255) NOT NULL default '',
  `streetnr` varchar(5) NOT NULL default '',
  `pcode` varchar(10) NOT NULL default '',
  `town` tinytext NOT NULL,
  `district` tinytext NOT NULL,
  `state` tinytext NOT NULL,
  `country` tinytext NOT NULL,
  `hits` int(6) NOT NULL default '0',
  `hot` tinyint(1) NOT NULL default '0',
  `sold` tinyint(1) NOT NULL default '0',
  `metadesc` varchar(255) NOT NULL default '',
  `metakey` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `created_by` int(11) NOT NULL default '0',
  `access` tinyint(3) NOT NULL default '0',
  `verified` tinyint(1) NOT NULL default '-1',
  `publish_up` datetime NOT NULL,
  `publish_down` datetime NOT NULL,
  `publish` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=385 ;

--
-- Tablo döküm verisi `jos_estateagent`
--

diye devam ediyor...
ben mister estatedeki verileri bu 2.sine geçirebilir miyim ? nasıl yapabilirim bunu ?

Oracle'da şöyle yapardım;
Bir imleç açıp, önceki tabloyu imlecin içine aktarıp,
İmleci satır satır fetch edip yeni tabloya aktarırdım.

MySQL'de nasıl yapılır bilmiyorum.