Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.29 KB | None | 0 0
  1. SELECT cf,nome,cognome
  2. FROM persona JOIN effettua ON cf=cf_med JOIN intervento ON ID_int=ID
  3. WHERE tipo='LASER'
  4. AND durata>2
  5. AND data_e_ora= (SELECT MIN(data_e_ora)
  6. FROM intervento
  7. WHERE ID=effettua.ID_int)
  8. AND cf_paz IN (SELECT cf
  9. FROM persona JOIN intervento ON cf=cf_paz
  10. WHERE sesso='F');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement