Ex:
Code: Select all
SELECT administracaoxitemxprescricao.CD_USUARIO, administracaoxitemxprescricao.DS_DIA, administracaoxitemxprescricao.DS_HORA,
administracaoxitemxprescricao.DT_DATA, year(prescricoes.DT_PRESCRICAO) as data_prescricao
FROM administracaoxitemxprescricao
join prescricoes ON prescricoes.CD_PRESCRICAO = administracaoxitemxprescricao.CD_PRESCRICAO
WHERE administracaoxitemxprescricao.CD_USUARIO = 1