create view memo
USE `leaf`; CREATE OR REPLACE VIEW `leaf`.`analysis_results_integrated` AS SELECT t6.subject, t6.Target_gene, t6.label, t6.Expression_profile as Expression_profile, t7.experiment_stress, t7.experiment_tissue, t7.Median, t7.label as t7_label, t8.label as Treatment, t9.label as Sample FROM `leaf`.`t6_h` t6, `leaf`.`t7_h` t7, `leaf`.`t8_h` t8, `leaf`.`t9_h` t9 WHERE t6.Expression_profile = t7.subject AND t7.experiment_stress = t8.subject AND t7.experiment_tissue = t9.subject ;