Re: UNION does not seem to work

[Frans Streur]

Tables:

CREATE TABLE IF NOT EXISTS `pedibase`.`TBL_Interacties` (
`Seq` INT NOT NULL AUTO_INCREMENT,
`Seq_Klant` INT NOT NULL,
`Interactietype` VARCHAR(20) NOT NULL,
`Datum` DATE NOT NULL,
`Uren` DECIMAL(5,2) NOT NULL DEFAULT 0,
`Opmerking` LONGTEXT NULL,
PRIMARY KEY (`Seq`),
UNIQUE INDEX `Seq_UNIQUE` (`Seq` ASC),
INDEX `FP_Klant_idx` (`Seq_Klant` ASC))
ENGINE = InnoDB;

-- -----------------------------------------------------
-- Table `pedibase`.`TBL_Activiteiten`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `pedibase`.`TBL_Activiteiten` ;

CREATE TABLE IF NOT EXISTS `pedibase`.`TBL_Activiteiten` (
`Seq` INT NOT NULL AUTO_INCREMENT,
`Seq_Acttype` INT NOT NULL,
`Datum` DATE NOT NULL,
`Uren` DECIMAL(2,2) NOT NULL DEFAULT 0.0,
`Opmerking` MULTILINESTRING NULL,
PRIMARY KEY (`Seq`),
UNIQUE INDEX `Seq_UNIQUE` (`Seq` ASC),
INDEX `FK_Uurtype_idx` (`Seq_Acttype` ASC))
ENGINE = InnoDB;