MySQL Forums
Forum List  »  Docs

Re: UNION does not seem to work
Posted by: Frans Streur
Date: February 05, 2017 11:19AM

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;

Options: ReplyQuote


Subject
Views
Written By
Posted
284
February 05, 2017 11:16AM
Re: UNION does not seem to work
154
February 05, 2017 11:19AM
145
February 05, 2017 02:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.