Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT servicio.ser_codigo,
- servicio.ser_nombre
- FROM servicio
- JOIN INGRESO ON INGRESO.SER_CODIGO=SERVICIO.SER_CODIGO
- JOIN FICHA ON FICHA.PAC_NUMFICHA = INGRESO.PAC_NUMFICHA
- WHERE FICHA.PAC_TIPO='A'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
