Kod:
CREATE TABLE `data1` (
`falt1` INT NOT NULL ,
`falt2` VARCHAR( 10 ) NOT NULL ,
`falt3` DATETIME NOT NULL ,
`falt4` FLOAT NOT NULL
) ENGINE = MYISAM ;
CREATE TABLE `data2` (
`falt1` INT NOT NULL ,
`falt2` VARCHAR( 10 ) NOT NULL ,
`falt3` DATETIME NOT NULL ,
`falt4` FLOAT NOT NULL
) ENGINE = MYISAM ;
INSERT INTO `data1` (`falt1` ,`falt2` ,`falt3` ,`falt4` ) VALUES ('100', 'Etthundra', '2011-01-27 10:00:00', '100.1');
INSERT INTO `data1` (`falt1` ,`falt2` ,`falt3` ,`falt4` ) VALUES ('200', 'Tvåhundra', '2011-01-27 11:00:00', '200.2');
INSERT INTO `data1` (`falt1` ,`falt2` ,`falt3` ,`falt4` ) VALUES ('300', 'Trehundra', '2011-01-27 12:00:00', '300.3');
INSERT INTO `data2` (`falt1` ,`falt2` ,`falt3` ,`falt4` ) VALUES ('110', 'Etthundratio', '2011-01-27 10:10:00', '400.1');
INSERT INTO `data2` (`falt1` ,`falt2` ,`falt3` ,`falt4` ) VALUES ('220', 'Tvåhundratjugo', '2011-01-27 11:10:00', '500.2');
INSERT INTO `data2` (`falt1` ,`falt2` ,`falt3` ,`falt4` ) VALUES ('330', 'Trehundratrettio', '2011-01-27 12:10:00', '600.3');
SELECT * FROM `data1` UNION SELECT * FROM `data2;