Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from R. N. Wilhite on Sep 26 at 1:00 PM Do you know what a left outer join does?
Neal
| | | ---------------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. __.____._ |   _.____.__ |
