Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT cf,nome,cognome
- FROM persona JOIN effettua ON cf=cf_med JOIN intervento ON ID_int=ID
- WHERE tipo='LASER'
- AND durata>2
- AND data_e_ora= (SELECT MIN(data_e_ora)
- FROM intervento
- WHERE ID=effettua.ID_int)
- AND cf_paz IN (SELECT cf
- FROM persona JOIN intervento ON cf=cf_paz
- WHERE sesso='F');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement