Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 07-02-2017
- CREATE OR REPLACE VIEW PatologieCurate AS
- SELECT E.Paziente, E.Patologia, P.Citta
- FROM esordio E INNER JOIN paziente P ON E.Paziente = P.CodFiscale
- WHERE E.DataGuarigione IS NOT NULL -- guarito
- AND YEAR(E.DataGuarigione) < 2015
- GROUP BY E.Paziente, E.Patologia;
- SELECT DISTINCT D.Paziente
- FROM (
- SELECT T1.Paziente, T1.Patologia, P1.Citta
- FROM terapia T1 INNER JOIN paziente P1 ON T1.Paziente = P1.CodFiscale
- WHERE (YEAR(T1.DataInizioTerapia) = 2015
- OR YEAR(T1.DataFineTerapia) >= 2015)
- AND
- T1.Farmaco = 'Oki'
- ) AS D
- LEFT OUTER JOIN
- PatologieCurate PC USING(Patologia,Citta);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement