読者です 読者をやめる 読者になる 読者になる

inohilog

/var/log/inohiro

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
;