Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Juan Garcia on Sep 26 at 12:59 PM I think that if you use left joins in your query you can check this URL help.sap.com/saphelp_nw04s/helpdata/en/cf/21ec7744 6011d189700000e8322d00/content.htm
| | | ---------------Original Message--------------- From: JohnScript Sent: Wednesday, September 26, 2012 10:02 AM Subject: Write Blank if No Email Address Exists I need to create a query where I report the information included in tables LFA1, LFBK, LFB1, TBAN, BNKA. At each record I need to link the email address I find in ADR6 table (field SMTP_ADDR). The problem is that no always I have an email address so the query if match an emaill address has to write this address otherwise if it does not exist the query has to write blank. How can I solve this situation ? | | Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today. _.____.__ |