Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT EML.CTM_NBR,
- EML.ADR_EMAL,
- ADR.PMO_ADR,
- EML.PMO_EML
- FROM CDSEML_M AS EML
- LEFT JOIN CDSADR_M AS ADR ON EML.CTM_NBR=ADR.CTM_NBR
- WHERE EML.PMO_EML='Y'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement